How to open an Access 97 MDB file today
Old .mdb files turn up in backups, on retired office PCs and in archives, and they often hold the only copy of something: a member list, a parts catalogue, years of records. Opening an Access 97 file is harder than it should be, because current Access no longer does.
Short answer
Access 2013 and later can’t open Access 97 databases. Either convert the file with Access 2010 or earlier, saving it in a newer format, or read it without Access: Keyfield opens Access 97 .mdb files on an Android phone, read-only, so the original isn’t changed.
Get Keyfield Opens .accdb and .mdb files. Viewing is free, with no account.
Why new Access won’t open it
Access 97 used an older version of the Jet database format than Access 2000 and later. Microsoft dropped support for it in Access 2013, so current versions refuse the file and ask you to convert it with an earlier version. Files from Access 2000 and 2002–2003 still open in current Access; it is the 97 ones that are stuck.
Option 1: convert it with an older Access
If you or a colleague still have Access 2010 or 2007 on a PC, open the Access 97 file there and save a copy in a newer format: .accdb, or the Access 2002–2003 .mdb format. The copy opens in current Access. Work on a copy, keep the original untouched, and check that the row counts match afterwards.
Option 2: read it on your phone
If you need to look things up rather than keep developing the database, you don’t need Access at all:
- Copy the
.mdbto your phone, or put it in Drive or email it to yourself. - Open it with Keyfield (step by step). The database screen shows the version, here “Access 97”, and every table with its row count.
- Search, filter and sort the tables, read a row as a form, and read the saved queries as SQL.
Keyfield opens the file read-only and says so at the foot of the database screen: nothing in the file is changed. That matters with an archive copy. To move the data into something current, Keyfield Pro exports any table to Excel or CSV, a one-time purchase.
Old files, old habits
- Passwords: an Access 97 database password is checked by Access when it opens the file; it doesn’t encrypt the data with the password. Keyfield opens these without asking for it (more on passwords).
- Files older than Access 97: Access 2.0 files from 1994 are older than Keyfield reads.
- A front end with links: old split databases often link to a back end on a drive that no longer exists. Those tables show where they pointed (linked tables).
Which is right for you
If the database is still in use, converting it is the long-term answer, and you need a PC with an older Access once. If you only need what is in it, a phone with a viewer gets you there today, and leaves the original exactly as it was. The difference between the two formats is covered in ACCDB vs MDB.
Read the old database without Access
Keyfield opens Access 97 to 2019 files on your phone, read-only. Viewing is free; exporting a table to Excel or CSV is part of Keyfield Pro.
