Please use code tags when posting code.
I stand corrected, you can access other databases from the SQL engine.
However, with a secured Access database, you have to set other options because Access does not use the username and pwd sections of a connection string.
You need to use
- ' Establish the location of the SYSTEM.MDA files if in another
-
' directory other than the \WINDOWS directory:
-
SetDataAccessOption 1, "C:\MYDIR\MYAPP.INI"
-
' Log on to a valid account:
-
SetDefaultWorkspace "admin", "<password>"
to set up the needed access.
Source:
http://support.microsoft.com/kb/113701
Also, according to the source, the connection only needs to be set up with the path
- [;database=C:\ACCESS\DB1.MDB]