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?
 
Top