Access 2010 connects to SQL Server 2008

Is it possible to directly connect Access 2010 to SQL Server 2008 without using ODBC?  If so, how?  Thanks.
thomaszhwangAsked:
Who is Participating?
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
I would not recommend using a ADP.  The have been depreciated. How much longer they will be supported is not guaranteed.  Probably not much longer.

I have always used a mdd/mde or a  accdb/accde with an SQL server back end.  I use a DNS-less connection. See: Using DSN-Less Connections

0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I agree with HTC, and Microsoft recommends that new server-backed database use linked tables.

Note also that you can use straight ADO connections to work with server-based data, if you're willing to handle the work of managing the data. This is known as an "unbound" application, and while it's a lot of work, it can also provide benefits as well. However, unless you're well-versed in the aspects of managing unbound data I'd suggest you stick with the bound scenario.
0
 
thomaszhwangAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.