We help IT Professionals succeed at work.

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

PattyAcc
PattyAcc asked
on
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!
Comment
Watch Question

CERTIFIED EXPERT

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

Author

Commented:
64 bit Access 2010
CERTIFIED EXPERT
Commented:
Have not tested (Access 64 have too many problems), but I think you need Microsoft Access Database Engine 2010 Redistributable:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255

Author

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

Explore More ContentExplore courses, solutions, and other research materials related to this topic.