What is the IN CLAUSE for an access database with password?

[Guest]

I'm writing, in Access 2003, a select query in which the source table is in
an external database protected with password, that I can't link to for other
reasons.

My last try was:

SELECT id from table1 in "" [database=dbprotected.mdb; pwd=myword;]

but I get the message 'could not find installable isam' (both the db are
access ones).

 

[Marshall Barton]

I'm writing, in Access 2003, a select query in which the source table is in
an external database protected with password, that I can't link to for other
reasons.

My last try was:

SELECT id from table1 in "" [database=dbprotected.mdb; pwd=myword;]

but I get the message 'could not find installable isam' (both the db are
access ones).

You need a semicolon before Database and the full path to
the file. I think you need to specify a value for UID
without a trailing semicolon.

You can see the exact connect string if you link to the
table and then look at the linked table's Connect property
in the Immediate window:

?CurrentDb.TableDefs!tablename.Connect

 

[Gary Walter]

I'm writing, in Access 2003, a select query in which the source table is
in
an external database protected with password, that I can't link to for
other
reasons.

My last try was:

SELECT id from table1 in "" [database=dbprotected.mdb; pwd=myword;]

but I get the message 'could not find installable isam' (both the db are
access ones).

In addition to Marshall's sage advice, I think you just forgot
to include the "isam," plus maybe will need full path?

SELECT id from table1
IN '' [MS Access;PWD=myword;DATABASE=C:\dbprotected.mdb]

I just used 2 single quotes in case trying to create
query string in code, but 2 double quotes will work....

good luck,

gary