Specify .mdw file in embedded connection string

J

Jamie Collins

onedaywhen wrote ...
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?
Click to expand...

I now know how to specify a userID and password e.g.

SELECT *
FROM
[MS Access;Database=C:\Tempo\AnotherDB.mdb;UID=Admin;PWD=***;].MyTable

What about the path to the .mdw?

Thanks,
Jamie.

--
 
Top