accdb format.Ĭlick File, click Save As, and then click Save Database As.Ĭhoose the Access file type, and then click Save As. To continue, see the section Convert an Access 97 database to the. NOTE If the Database Enhancement dialog box appears, the database is using a file format that is earlier than Access 2000. accdb file format.Ĭlick the Access 2000 or Access 2002 - 2003 database (.mdb) that you accdb file format, you must first open the database by using Access 2007, Access 2010, or Access 2013, and then save it in the. To convert an Access 2000 or Access 2002 - 2003 database (.mdb) to the.

On the File tab, click Save As, select Access Database (*.accdb),Īnd then click Save As.

Enter a name for the database, and then click Save.

On the Tools menu, click Database Utilities, click Convert Database,Īnd then click to Access 2002-2003 file format.

Open the Access 97 database in Access 2003.

Īlso refuses to read Access 97 files (with the same error message cited in the question). The Access 2013 version of the newer Access Database Engine ('ACE') ODBC driver. which ships with Windows but is only available to 32-bit applications. *Important: The import needs to be done using the older Jet ODBC driver.

Or, if your goal was simply to get the data out of the Access 97 file then you could continue to work with it in SQL Server, or move it to some other platform, or whatever. Access 2013 adamantly refused to have anything to do with the Access 97 file, but SQL Server imported the tables without complaint.Īt that point you could import the tables from SQL Server into an Access 2013 database. I just tried that with a 32-bit version of SQL Server 2008 R2 Express Edition and it worked for me. have the SQL Server import utility use Jet * ODBC to import the tables into SQL Server.install a 32-bit version of SQL Server Express Edition, and then.In that case, a possible workaround would be to Unfortunately, from now on many people will have difficulty getting their hands on a legitimate copy of Access 2003 (or any other version prior to Access 2013, or whatever the latest version happens to be). As noted in another answer, the official word from Microsoft is to open an Access 97 file in Access 2003 and upgrade it to a newer file format.

Ms access 2003 portable