Send Password in Remote Query

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!
 
G

Guest

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

Set db = wrkdefault.OpenDatabase("c:\database.mdb" , True, False, "MS
Access;PWD=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

query in another database 3
Windows 10 W10 password prob. 2
Are password protected WiFi networks secure? 3
Using INSERT INTO to open a password protected database. 1
Not a valid password error 2
Multiple make table queries in one? 3
ODBC DSN query issue 1
"In" Query Question 2

Top