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.