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 wrote:
> 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.