Migrating Access 97 to Sql Server - Version Error
0
votes
0
answers
594
views
I have Sql Server Migration Assistant for Access v2.7, running on Windows Server 2016. On the same server I have 64bit version of Access 2016 and a 32bit version (I assume) of Access 97.
I am able to migrate Access 2007.accdb files on this server. However, when I click add database and choose an Access 97.mdb file I get the following error:
*"Cannot open a database created with a previous version of your application."*
Is it possible to migrate (directly) from Access 97 using this tool?
The following link suggested it should be:
https://learn.microsoft.com/en-us/sql/ssma/access/sql-server-migration-assistant-for-access-accesstosql
*Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access versions 97 through 2010 to Microsoft SQL Server 2005 / Microsoft SQL Server 2008 / Microsoft SQL Server 2012 / Microsoft SQL Server 2014 / Microsoft SQL Server 2016 / Microsoft SQL Server 2017*
Asked by Rob Bowman
(271 rep)
Feb 24, 2018, 12:39 PM
Last activity: Feb 24, 2018, 01:22 PM
Last activity: Feb 24, 2018, 01:22 PM