How do I automatically enter the password for a database tablename

O

OWU

I am writing a macro that will take two database tables and merge the records
into one table and then import them back into both tables. When I run the
macro, I am prompted to enter the database table's password 8 times. Is
there a way to have the macro automatically enter the tablename password?
 

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

Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
How do I clear a form? 0
Username Password Issues 0
VBA word change keys 0
Password for Transfer Database 1
Some mail merge fields not pulling into document 2
Finding the right style field in VBA 0
embedding pw's to master sheet & auto update w/out pw's 0

Top