Specify .mdw file in embedded connection string

O

onedaywhen

I can use the following syntax to select data from another .mdb file:

SELECT * FROM [Database=C:\Tempo\AnotherDB.mdb;].MyTable

alternatively

SELECT * FROM MyTable IN 'C:\Tempo\Another.mdb'

Does anyone know if it's possible to extent this to use workgroup
security i.e. specify a .mdw (system.mdw) file plus userID and
password?

Thanks.

--
 
Top