Access/SQL Server Solutions utilizing ADO Libraries

Question

Hi Microsoft,

After reading the thread on the depreciation of OLE DB I’ve very concerned about my Access/SQL Server productions and solutions.

I have applications that utilize Access 2003/2007/2010 with SQL Server 2005 and 2012.  They have no local tables and communicate with SQL Server via ADO to execute stored procedures and execute SQL statements. 

Does this mean the next version of SQL Server will not support connection from Access using ADO?

Performance is incredible with this setup and the application can be run on any machine anywhere in the world.  I’ve been running this solution for almost a decade and am very saddened that I will have to rethink the entire application and deployment.

One of Accesses strengths is its ability to work seamlessly with SQL Server.  Does this mean that Access is going to undergo some serious fundamental changes?

I noticed that in the new version of MS Access (2013), the SQL Server migration command on the Database Tools tab is no gone.

Please help me understand what exactly is being deprecated and what direction an Access/SQL Server solution should be moving.

Thanks,

Michael Stalford

Founder and COO

Business Software International Inc

www.softwaresolution.com

Answer 1

Hi Michael,

I think only SQL Server develop team guys can answer this question, since the new SQL Server is not published.

In my opinion, linked server from SQL Server to Access won't be removed.

Based on your scenario, you are connecting SQL Server using ADO from Access, if ADO is not removed, Access can still connect to SQL Server. One thing unclear is that MS Access 2013, since this forum is related to connect Access or other data source from SQL Server, your question is connect SQL Server from Access, I think it is better to ask Access develop guys for more information.

---

Iric Wen
TechNet Community Support