FROM table IN database - with db password

C

CDB

A2K. How do I pass the database password for an external Jet database in the
SQL statement, eg:

SELECT *
FROM Contracts IN 'C:\Access\ContractProg.mdb'

My attempts have all produced Error 3031 - not a valid password.

Thanks.
Clive
 
Top