Problem with exporting

J

Jared

I have a secured MS Access database and I'm trying to
export a table to another MS Access database that is
protected by a single password. I can successfully do
this manually but I'm trying to automate this function so
a user can click a button to perform this task. I have
used a macro to perform this task and I have tried using
VBA code. Both have the same outcome, the macro runs and
it prompts me for the password then stops without
transferring anything. In both instances I have used
transferdatabase method.

If you have any information or tips they would be greatly
appreciated. If you need more information on my problem
please contact me at [email protected]

Thanks!
 
Top