Exporting tables out to a password protected db

J

Julie

I am trying to use some code to export some tables from one password
protected database out to another password protected database without having
to type the password in for either of them. So I am using the OpenDatabase
action to open the database I am exporting to and supplying it's password,
but when I try to export out to it, I get prompted for the password of the
database I am exporting from. Seems simple to me, but it has me stumped.
Can someone help? I am trying to put all this in a macro that will run when
user presses a button, just do not want them to have to enter passwords.

Thanks,
Julie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting Word 2019 document 0
Password protect new workbooks from template 0
Compacting a password protected database using vba 0
Password Question/Access 2007 3
Check if back end is (still) password protected 0
Secure db with one password and no user-level? 1
Password for project lost 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top