<div>
Is it 64 bit Windows 7 and Access or 32 bit?
</div>


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

<div>
I downloaded it, and that must have done it.&lt;br /&gt;&lt;br /&gt;Thanks!
</div>


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

<div>
<div class="content wysiwyg-content">
I have a new pc running Windows 7, Access 2010. &nbsp;We have a SQL 2008 database I'm trying to connect to. I don't have any SQL software on my pc.<br />
<br />
I connected the SQL ODBC source, and it tests out fine and shows it exists in &quot;Data Sources&quot; in the Control Panel. &nbsp;But it doesn't show in Access 2010.<br />
<br />
When I try to add a new ODBC source in Access, it says I don't have administrator privileges.<br />
<br />
&nbsp;I added the admin account on my pc. &nbsp;I log into that account and try to connect the SQL database. No luck.<br />
<br />
&nbsp;I've tried running the suggested solution earlier of right clicking on Access, Run as Administrator, and it still doesn't show.<br />
<br />
I have an older pc running Windows XP, Access 2003 and it works fine.<br />
<br />
<br />
Please help!
</div>
</div>


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!

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

Windows 7 is an operating system from Microsoft. Features include multi-touch support, a redesigned Windows Shell with a new taskbar, referred to as the Superbar, a home networking system called HomeGroup, and performance improvements.

Windows 7

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.