Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Data Projects - ADP _ Adp To SQL Server 2016

Posted by: jameswbrown May 26 2017, 09:47 AM

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.

Posted by: Dan Dungan May 26 2017, 01:58 PM

According to this http://www.dummies.com/software/microsoft-office/access/finding-alternatives-to-access-data-projects/, 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.

Posted by: PhilS Jul 29 2017, 04:57 AM

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.

Posted by: NormOlsen Sep 25 2017, 04:18 PM

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.