ODBC in Windows 7 - 32-bit applications

[KeyserSoze]

I have recently converted from Windows XP to Windows 7 (64-bit). I have discovered that my 32-bit ODBC connections in my Microsoft Access database no longer work. From doing some research, it suggests that I create new system DSN's using the ODBC administrative tool (odbcD32.exe) located in directory C:\Windows\sysWOW64, which I have done.

However, when I go into my Microsoft Access database to try and update the links in my tables, the Machine Data Source list still shows the old DSNs and none of the new ones that I have created.

Is there a way in Microsoft Access 2010 to tell it to use my new DSN or will I have to do this outside of Microsoft Access?

 

[genomon]

If you are talking about linked tables, you will need to refresh/recreate the links using the new dsn.

Beir bua agus beannacht!

 

[KeyserSoze]

I have created the new DSNs using the SYSWOW64 version of odbcad32.exe. The problem is when you go into the linked table manager in Microsoft Access, it only sees the old DSNs and not the new ones. How does one 'refresh' the links?

Is there a registry modification that has to made?

 

[genomon]

Don't use linked table manager - try deleting the tables and relinking with the wizard.

Beir bua agus beannacht!

 

[KeyserSoze]

I have tried that method. It doesn't work.

 

[genomon]

Rats.

Beir bua agus beannacht!