Make table query to update other password-protected database

A

arich

When I set up a make table query to update a table on another database, I am
required to enter the password for the receiving database. However, when I go
to run the query, I can't get it to run without first turning off the
password on the receiving database. Is there a way to make it unnecessary to
turn off the password on the database on which the table is being created?
 
B

Barry Gilbert

You might be able to use an ODBC string in the query's Dest Connect Str
property. Look on the query's property sheet for this property.

HTH,
Barry
 
Top