I have an old MS Access 2000 application which connects to a SQL Server 2000 database. I need to migrate this database and application to a new server with SQL Server 2012. The Access application is running locally on my user's workstation.

Should I upgrade the Access database to a new version then create a new connection to the 2012 SQL Server (new adp file)? The application is unsupported and we need to move the database to a new server.

closed as too broad by John aka hot2use, mustaccio, Erik Darling, Andriy M, McNets Apr 10 '18 at 8:56

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • what have you tried? also, sql server 2017 is out, if you're upgrading why not go to a more recent version? – DForck42 Apr 5 '18 at 16:43

I highly recommend you use an .accdb file, not an .adp file. Support for .adp has been removed since Access 2013.

Migrating will vary depending on the application, but quite often isn't an issue at all. Access has high compatibility between versions, and so has MS SQL server.

You can ask about specific problems here or on Stack Overflow depending on the nature of the problem.

Not the answer you're looking for? Browse other questions tagged or ask your own question.