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
 
Ad

Advertisements

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

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

Top