Microsoft Access ODBC in both 32 and 64 bit OS environments

Hey experts! I have a client who has users with both 32 and 64 bit OS's. They have 32 bit Office installed universally.

For non-terminal server (TS) users everything works fine... for the 64-bit Terminal Server users however, the ODBC connection is not working.

When logging into TS as administrator we open Windows\SysWow64\odbcad32.exe and see the connection and can test it successfully.

From within the Access application however, when I try to link to the ODBC table it only brings up the non 64-bit odbc driver.

Any suggestions??
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Try creating the link from within Access, instead of using the odbcad32.exe utility. You can set it as a "Machine Data Source", which should expose it to everyone using the TS box (but if not, you'd just have to rebuild on each TS user).

Better yet, don't even use a DSN, and instead relink the tables with DSN-less connections:

http://www.accessmvp.com/djsteele/DSNLessLinks.html

It's a little more work, but much more robust. I've used this technique for many, many years with great success on many different platforms (including TS).
0
 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Thanks a lot!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.