G'day,
I am trying to create an ODBC link to a copy of the Northwind data base.
I am running Win7 on a 64 bit operating system but am keeping office running as 32 bit for Access, Excel , Visio etc due to the fact that I have a lot of old apps tied to them.
When I attempted initially to create a new system DSN ODBC connection it only allowed me to use SQL drivers. (No plurry good) So after some searching I found out that I could use a file in C:\Windows\SysWOW64 called "odbcad32.exe" which has allowed me to view /use the total list of drivers to import data.
So I can set up a DNS ODBC named Northwind1 and I can access the database without problems using Excel.
However if I try to use the same ODBC link in Access to connect to Northwind1 I get the following error message:
"You cannot use ODBC to import from export to, or link an external ?Microsoft Access or ISAM database table to your database"
What am I missing? This is driving me crazy.
I am trying to create an ODBC link to a copy of the Northwind data base.
I am running Win7 on a 64 bit operating system but am keeping office running as 32 bit for Access, Excel , Visio etc due to the fact that I have a lot of old apps tied to them.
When I attempted initially to create a new system DSN ODBC connection it only allowed me to use SQL drivers. (No plurry good) So after some searching I found out that I could use a file in C:\Windows\SysWOW64 called "odbcad32.exe" which has allowed me to view /use the total list of drivers to import data.
So I can set up a DNS ODBC named Northwind1 and I can access the database without problems using Excel.
However if I try to use the same ODBC link in Access to connect to Northwind1 I get the following error message:
"You cannot use ODBC to import from export to, or link an external ?Microsoft Access or ISAM database table to your database"
What am I missing? This is driving me crazy.