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.
--
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.
--