IN clause on password protected external mdb

[geoleo68]

I'm trying to create a series of queries to append data from an external
password protected mdb file.

I can't find the correct way to structure the IN clause of my query to allow
access on the protected file.

Right now I have tried this

SELECT * INTO NewTable1 FROM Table1 IN "C:\MyDir\MyPwProtectedDB.mdb"

This causes an "Not a valid password" message when tried to be ran.

and this

SELECT * INTO NewTable1 FROM Table1 IN "C:\MyDir\MyPwProtectedDB.mdb
password=MyPw"

This causes a "Could Not find file" message.

Hope someone can help me out.

 

[ErezM via AccessMonster.com]

hi
why dont you link the to the tables you need from the other mdb file (the
password is needed only during the linking proccess and not afterwards)
then you can build your query on local and linked tables, all residing inside
your current mdb

Erez