Can't connect to SQL 2008 from Access 2010/Windows 7

Posted on 2012-03-12
Medium Priority
Last Modified: 2012-03-14
I have a new pc running Windows 7, Access 2010.  We have a SQL 2008 database I'm trying to connect to. I don't have any SQL software on my pc.

I connected the SQL ODBC source, and it tests out fine and shows it exists in "Data Sources" in the Control Panel.  But it doesn't show in Access 2010.

When I try to add a new ODBC source in Access, it says I don't have administrator privileges.

 I added the admin account on my pc.  I log into that account and try to connect the SQL database. No luck.

 I've tried running the suggested solution earlier of right clicking on Access, Run as Administrator, and it still doesn't show.

I have an older pc running Windows XP, Access 2003 and it works fine.

Please help!
Question by:PattyAcc
  • 2
  • 2
LVL 41

Expert Comment

ID: 37713247
Is it 64 bit Windows 7 and Access or 32 bit?

Author Comment

ID: 37713817
64 bit Access 2010
LVL 41

Accepted Solution

als315 earned 2000 total points
ID: 37714523
Have not tested (Access 64 have too many problems), but I think you need Microsoft Access Database Engine 2010 Redistributable:

Author Closing Comment

ID: 37722455
I downloaded it, and that must have done it.<br /><br />Thanks!

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

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

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In a question here at Experts Exchange, a member was looking for "a little app that would allow sound to be turned OFF and ON by simply clicking on an icon in the system tray". This article shows how to achieve that, as well as providing the same OF…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

600 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