Make table query to update other password-protected database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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