My company is using MS Access 2007 projects (.adp) with SQL 2005 very successfully. Now the company will beto upgrading to SQL 2012. Will there be a compatability or connection issues with our current Access 2007 projects and the new SQL 2012? Thanks for any advice you can offer.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Access 2007 .adp use with SQL 2012
- Thread starter batteam
- Start date
Before I swore off ADP's I realized they seem to work or reconnect to SQL Server databases across versions but that was more like moving to 2005. My expectation is that it would still work but you may no longer have native object support within Access 2007. And ADP's were deprecated in some version... So better to move away at your earliest convenience.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question