TransferDatabase from MDE w/ password

[Brandon R.]

I am trying to use the transfer database action in a macro
to import a table from an MDE into the mother MDB file. I
am prompted for the MDE password and it appears to run
without errors but when checking my tables there is no
imported table.

I have googled and msdn'd and searched here as well; I
cannot find anything. I have found others with the same
question, but no responses.

Thanks for the help,
Brandon R.
Access 2000

 

[Petrucci2000]

Hi,

My name is Eric. Thank you for using the Microsoft Access Newsgroups.

You wrote:
"...transfer database action in a macro to import a table from an MDE into
the mother MDB file. I
am prompted for the MDE password and it appears to run without errors but
when checking my tables there is no imported table..."

Have you tested with the Northwind database sample? I've tested with
Northwind without any problems using MDE file with Password. It's very
possible that it maybe strictly related to your database (e.g., corruption
in table, table name being used, Access keywords used in database, etc..).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."