Can't connect to SQL 2008 from Access 2010/Windows 7
Posted on 2012-03-12
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.