Stuart McLachlan
stuart at lexacorp.com.pg
Thu Jan 30 18:06:01 CST 2003
> > MSAccess2000 > TransferDatabase Method > "saveloginid" optional argument > > MSAccess2000 help gives me "Use True to store the login identification > (ID) and password for an ODBC database in the connection string for a > linked table from the database. If you do this, you don't have to log > in each time you open the table. Use False if you don't want to store > the login ID and password. > > If you leave this argument blank, the default (False) is assumed. > > This argument is available only in Visual Basic." > ================================ > > I'm trying to use the True value and it doesn't seem to work. See below. > > DoCmd.TransferDatabase acExport, "Microsoft Access", _ > dbsNewName, TheCopyType, AName, AName, , True > > Does "only in Visual Basic" mean "not in VBA" ? > No it means VBA. What sort of ODBC database is the Access database linked to? How do the connection strings in the linked tables compare in the old and new databases? Examples? -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.