[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 370
  • Last Modified:

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

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!
0
PattyAcc
Asked:
PattyAcc
  • 2
  • 2
1 Solution
 
als315Commented:
Is it 64 bit Windows 7 and Access or 32 bit?
0
 
PattyAccAuthor Commented:
64 bit Access 2010
0
 
als315Commented:
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
0
 
PattyAccAuthor Commented:
I downloaded it, and that must have done it.<br /><br />Thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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