Solved

Microsoft Access ODBC in both 32 and 64 bit OS environments

Posted on 2013-01-25
2
331 Views
Last Modified: 2013-01-28
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
Comment
Question by:Ei0914
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 38821773
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
 

Author Closing Comment

by:Ei0914
ID: 38827200
Thanks a lot!!!
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question