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

Diego Cattaruzza wrote:

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

--
Marsh
MVP [MS Access]
.