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!
Thanks,
Randy
