I have an Access database which holds linked tables to a Unix system called Logic.
I need to write a procedure in VBA which takes the linked tables and puts them into the SQL Server database, called HOLT.
If I link tables to the Holt database, Access sees it fine.
However, when I try to use VBA to open the SQL Server database I get an error
"can't find E:\dob.mdb"
the VBA is:
Public db2 As Database
'sends logic tables to the SQL Server, Holt datbase.
'sets variable for the SQLServer Database
Set db2 = DBEngine.OpenDatabase("Holt", False, False, "ODBC;DSN=HOLT;SERVER=HOLT_SQL")
Can someone please tell me why it is looking fora .mdb file instead of the SQL server database??