Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Office XP on Windows 7 64 ODBC not linked

Posted on 2010-11-30
3
Medium Priority
?
384 Views
Last Modified: 2012-05-10
Ever since 2002 I have been developing on Office XP developer edition and still have quite a few databases running Access XP front ends with either SQL Server or MySQL backends. Converting them all is not an option.

I recently moved my main machine to Windows 7 64bit and so far everything seemed to work, until now.

I can open up the ODBC control panel and create a connection to my server (Server 2008) which has both SQL Express 2008 and MySql 5.x on it, connections here to both are fine. I can open the MySQL query browser on my Win7 machine and execute queries on the server just fine. Now when I open Access XP's linked tables dialog the ODBC connections I entered in the Windows 7 control panel are not there. When I create a new one in Access pointing to the SQL Server it works fine but it does not show up in the Windows 7 ODBC control panel.

This may not be an issue, or it may be. Since the end user will have an Access runtime instead of a full blown copy they will not have a way to set up a ODBC connection unless they can do it from the Windows ODBC control panel.

Suggestions?
0
Comment
Question by:AMPLECOMPUTERS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Accepted Solution

by:
TTauri earned 2000 total points
ID: 34238946
There are two versions of the ODBC management program in 64 bit Windows - the one in control panel is for 64 bit applications, but your copy of access is probably 32 bit and using the 32 bit ODBC drivers.

You can get to the 32 bit version here:
C:\Windows\SysWOW64\odbcad32.exe

Run that, create ODBC connections and they will apear in Access.
0
 
LVL 85
ID: 34239005
What's your concern? It's not clear from your question. Generally, you would provide the connection for your end users (and many use DSNless connections - see here for more details: www.accessmvp.com/DJSteele/DSNLessLinks.htm).

If you just fire up the ODBC Administrator in Win7 64-bit, you'll see only the 64-bit drivers. If you want to view the 32-bit drivers, you'll have to run the odbcad32.exe, located in the <Root>\SysWow64 folder. This will show you the 32-bit drivers.

See here:
http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/685eacc1-a670-42d4-8392-924230fa90cb

0
 

Author Closing Comment

by:AMPLECOMPUTERS
ID: 34239065
OK, now I feel better. Everything I entered into Access was right there waiting on me. Now that I know I can get to both, I feel more comfortable going forward. Thanks!
0

Featured Post

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

610 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