Solved

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

Posted on 2012-03-12
4
345 Views
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!
0
Comment
Question by:PattyAcc
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

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

Author Comment

by:PattyAcc
ID: 37713817
64 bit Access 2010
0
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 37714523
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
 

Author Closing Comment

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

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

777 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