Monday, January 28, 2013 2:46 PM
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.
Founder and COO
Business Software International Inc
Thursday, January 31, 2013 7:39 AMModerator
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.
TechNet Community Support
- Marked As Answer by Iric WenModerator Wednesday, February 06, 2013 7:41 AM