Send Password in Remote Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

N. Cotton - 29 Sep 2006 14:24 GMT

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!

Reply to this Message

N. Cotton - 29 Sep 2006 16:54 GMT

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

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

> Is there a way to pass a password using a remote Query?
>
[quoted text clipped - 7 lines]
>
> Many thanks!

Reply to this Message