Send Password in Remote Query

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

Guest

Is there a way to pass a password using a remote Query?

If the following "c:\database.mdb" is password protected, running the
following results in a "not a valid password" error. Is there a way to pass
this password with the query?

SELECT *
FROM EMPLOYEES
IN 'c:\database.mdb'

Many thanks!
 
I got around this problem by opening the database first with:

Set db = wrkdefault.OpenDatabase("c:\database.mdb" , True, False, "MS
Access;PWD=Password")
 
Back
Top