[AccessD] TransferDatabase Method - TransferDatabase Method

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.






More information about the AccessD mailing list