UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Adp To SQL Server 2016, Access 2007    
 
   
jameswbrown
post May 26 2017, 09:47 AM
Post#1



Posts: 22
Joined: 14-March 11



I have a client that is trying to move some Access 2003 ADP/SQL Server 2008 to a new SQL Server 2016. They have Access 2007 installed on the new Windows 2012 server and I can get it to open a ADP and connect to the 2016 SQL server. But I'm getting "not responding" from Access intermittently. When reports using Stored Procedures run I'm getting timeout errors or even "does not exist" for the SP.

Now I know that what needs to happen is to redevelop these ADP's. But I'm wondering if anyone has gotten a similar environment to work as a temporary solution.
Go to the top of the page
 
Dan Dungan
post May 26 2017, 01:58 PM
Post#2



Posts: 242
Joined: 20-July 10
From: chatsworth, ca


According to this Link, If you’re a user of Access 2000 through 2010, you may be familiar with Access Data Project (ADP) files — Access data files that provide access to SQL Server databases. Access 2013 drops support for the ADP format, and Microsoft recommends one of the following alternatives:

Continue using the same version of Access. ADPs continue to work in earlier versions of Access. They won’t work, however, with newer versions of SQL Server such as SQL Server 2012 and SQL Server Azure.

--------------------
Dan
Go to the top of the page
 
PhilS
post Jul 29 2017, 04:57 AM
Post#3



Posts: 378
Joined: 26-May 15
From: The middle of Germany


I know, this is several months old, but I can't refrain from commenting on this incorrect statement.
QUOTE
ADPs continue to work in earlier versions of Access. They won’t work, however, with newer versions of SQL Server such as SQL Server 2012 and SQL Server Azure.

Yes, ADPs will not work with newer version of Access than Access 2010. But the statement about SQL-Server is incorrect. I've got several ADP-Applications working with SQL-Server 2014 (none with SQL 2016 or Azure yet). So, it is definitely incorrect to say ADPs will not work with SQL 2012 and 2014.

--------------------
An excursion to the raw COM API with VBA: How to hide the Taskbar Button of a window.
Go to the top of the page
 
NormOlsen
post Sep 25 2017, 04:18 PM
Post#4



Posts: 1
Joined: 25-September 17



I've been working with a very complex (over 100 forms) Access 2007 ADP connected to SQL Server 2016 and have not encountered any problems or issues. The previous back end was SQL Server 2008.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    23rd October 2017 - 11:14 PM