By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,242 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,242 IT Pros & Developers. It's quick & easy.

DoCmd.TransferDatabase saveloginid flag working?

P: n/a

I'm trying to copy some ODBC linked tables from one access2k mdb to another.

This is an example of the code i'm using:
DoCmd.TransferDatabase acExport, "Microsoft Access", (strPath &
strTemp), acTable, "woCost", "woCost", False, True

I do not have to provide login information when I open the link in my 'home'
mdb file (I've used the 'save password' check when I originally setup the

After I run the above code - I am prompted for login credentials when I open
the ODBC link in the target mdb.

Am I missing something here or is this a bug?

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.