Results 1 to 1 of 1
2002-04-22, 16:19 #1
- Join Date
- Feb 2002
- Thanked 0 Times in 0 Posts
TransferDatabase method fails if MDB has password (A2K)
I have several of the following lines in a module to import various tables:
DoCmd.TransferDatabase acImport, "Microsoft Access", FE_Path, acTable, "Current Hierarchy", "Current Hierarchy", False
Some of the tables are in a password protected front-end Access database. The variable FE_Path is populating correctly with the front-end database path, as evidenced by the de######, as well as the fact that I'm prompted for that database's password. I am entering the password correctly when it prompts.
Both the source and destination database were Access 97 databases that were converted (not enabled) to Access 2000. ***This worked fine in Access 97***
This is driving me nuts! Help!