how to create project .adp in Access 2007 or 2010 using SQLServer

O

Olga

I don't see any option in ACCESS 2007 and ACCESS 2010 to create a connection
with SQL SERVER without ODBC. I have SQL server 2008.

Thank you for your help.

Olga
 
B

Banana

Olga said:
I don't see any option in ACCESS 2007 and ACCESS 2010 to create a connection
with SQL SERVER without ODBC. I have SQL server 2008.

Thank you for your help.

Olga
Click to expand...

Are you sure you created an .adp file and not an .accdb?

In 2007 or 2010 there is no button or option to create an .adp file- you
would "Create a new blank database" then explicilty suffix the .adp to
the file for it to be treated as a .adp.

Even then, why? .adp has not been enhanced for awhile, and the
recommendation is to use .accdb with ODBC. Furthermore, note that SQL
Server natively implements ODBC so there is minimal performance
difference between a ODBC driver or a OLEDB driver.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I create an adp in access 2010 2
Date issue in Access 2007 SQL 4
Access 2007 development in Access 2010 3
Using MDE file to connect to SQLServer via ODBC 1
MS Access 2010 Web Application with SQL server 0
Subdatasheet error on ADP projects in Access 2010 8
Unable to make design changes in .adp connected to SQL server 2008 1
Linking in Access to a specific Outlook email 4

Top