Access database won’t open on your phone? Five reasons
You tapped the .accdb or .mdb someone sent you and got nothing, or an error. When an Access database won’t open on a phone, it is almost always one of these five things, and each has a fix.
Short answer
In order of how often it happens: there is no app on the phone that reads Access files; the file is locked with an Access 2010 or later password; what you have isn’t the database (a zip, a lock file, a spreadsheet); the download didn’t finish; or the table you want is only a link to data stored somewhere else.
Get Keyfield Opens .accdb and .mdb files. Viewing is free, with no account.
1. Nothing on the phone reads Access files
Android has no built-in viewer for Access databases, and Microsoft has never made Access for phones. Office apps open documents and spreadsheets, not databases. Install a viewer made for the format, then open the file again from your email or Drive: the step-by-step is in how to open an ACCDB file on Android.
2. It’s locked with an Access 2010+ password
From Access 2010 on, setting a database password encrypts the whole file with a newer, stronger method. Keyfield can’t open that kind yet, even with the right password, and says so: “locked with Access 2010+ encryption”. Nothing is wrong with the file.
- Ask whoever sent it for a copy without the password.
- Or, in Access on a PC: open it with Open Exclusive, then File › Info › Decrypt Database, and send yourself that copy.
Older passwords behave differently: an .mdb database password opens free in Keyfield, and an Access 2007 password opens with Keyfield Pro. The details are in password-protected Access databases on Android.
3. It isn’t the database
The name looks right, but the file is something else:
- A zip. Databases are often zipped for email. Unzip it first and open the
.accdbor.mdbinside. - A lock file (
.laccdbor.ldb). Access makes these while the database is open; they hold no data. - A spreadsheet, a PDF or a Word file exported from the database, or renamed. Keyfield checks what the file really is and tells you (“This is a PDF file, not an Access database”).
4. The download didn’t finish
An attachment that stopped half-way still has the right name, but the end of the file is missing. Keyfield reports these as “the file ends early” or “this file is empty”. Save the attachment again, or download it again from Drive, and open the new copy. If it still fails, ask for a fresh copy: the sender’s file may itself be damaged.
5. The table is a link, not data
Many business databases are split in two: one file holds the forms and queries, the other holds the data. The first one only stores links to the tables in the second, or to a server. If you were sent the first file, the database opens but those tables are empty shells. Keyfield marks them LINKED and shows where each one points. See what a linked table is for what to ask for.
Two rarer cases
- Very old files. Keyfield reads Access 97 onwards; a file from Access 2.0 (1994) is older than it reads. Ask for a copy converted to a newer format.
- Very large files. 2 GB is the most an Access database can be. A larger “database” is a different kind of file.
Find out why yours won’t open
When Keyfield can’t open a file, it says why in one sentence and what to try next, instead of “error”. Viewing everything it can open is free.
