• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

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??
0
Eileen Murphy
Asked:
Eileen Murphy
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now