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

  • Thread starter Thread starter Olga
  • Start date Start date
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
 
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.
 
Back
Top