How to open an ACCDB file on Android
An .accdb file is a Microsoft Access database. Android has nothing built in that reads one, and Microsoft has never made Access for phones, so tapping the attachment usually ends in “no app can open this file”. Here is what works, and what to do when it still won’t open.
Short answer
Install an Access database viewer, then open the file from where it already is: tap the attachment in your email app, or the file in Drive or Files, and pick the viewer under Open with. Keyfield opens .accdb and .mdb files from Access 97 to Access 2019 and lists every table with its row count. Viewing is free. Files locked with an Access 2010 or later password are the one common case it can’t open yet.
Get Keyfield Opens .accdb and .mdb files. Viewing is free, with no account.
Why your phone can’t open it
An Access file is not a document. It is a database: tables of rows, the saved queries someone built on top of them, the relationships between the tables and, in the full desktop program, forms, reports and code. .accdb is the format Access has used since Access 2007; .mdb is the older one, from Access 97 to 2003. The difference is explained in ACCDB vs MDB.
Phone office apps open documents and spreadsheets, so they have nothing to show you. You need an app that understands the database format itself.
Step by step with Keyfield
- Install Keyfield from Google Play.
- Open the file from where it is. In Gmail or another email app, tap the attachment and choose Keyfield. In Drive or Files, tap the file, then Open with → Keyfield. You can also start in Keyfield and tap Open a database, which brings up Android’s own file picker.
- Nothing else on your phone is touched. Keyfield copies the one file you chose into its own private storage and reads it there. It never asks for permission to see all your files.
- Pick a table. The first screen lists every table with its row count. Tap one to get a grid you can scroll both ways.
- Find what you came for. Search every column at once, add a filter (“Amount more than 500”, “Status is Open”), sort by any column, and drag a column’s edge to widen it. Tap a row to read it as a form, one field per line.
The Queries tab shows the saved queries as SQL, Relationships shows how the tables connect, and each table’s Fields tab lists every field with its type. No file handy? The first screen has a sample database to try.
If it still won’t open
Keyfield names the reason instead of showing “error”. The common ones:
| What Keyfield says | What it means | What to do |
|---|---|---|
| Locked with Access 2010+ encryption | The file has a password set in Access 2010 or later. That kind of lock isn’t supported on Android yet. | Ask for a copy without the password, or in Access on a PC open it with Open Exclusive, then File › Info › Decrypt Database. |
| Access password · Keyfield Pro | An Access 2007 password. | Keyfield Pro opens it once you type the password. |
| This is a zip or Office file | You have the archive or a spreadsheet, not the database. | Unzip it first and open the .accdb or .mdb inside. |
| The file ends early / is empty | The download didn’t finish. | Save the attachment again and open the new copy. |
| Linked, not stored here | One table is a link to another file or a server. | See what a linked table is. |
All five, with more detail, are in why an Access database won’t open on your phone. Passwords have their own guide: password-protected Access databases on Android.
What is free, and what is Keyfield Pro
Opening and reading are free, with no limit on the number of files, tables or rows. Keyfield Pro is a one-time purchase, not a subscription. It adds exporting a table, or just the rows you filtered, to Excel, CSV or PDF; saving the files stored in attachment fields; opening Access 2007 password files; and sharing any export. An .mdb with a database password opens free.
What it won’t do
Keyfield is a reader. It doesn’t change anything in the file and has no way to edit data. It shows saved queries as SQL but doesn’t run them (how to read them), and it doesn’t show Access forms, reports or macros. If you need to change the data, you need Access on a PC, or an app that edits.
Open the file you were sent
Keyfield opens .accdb and .mdb files from Access 97 to 2019, from email, Drive or any “Open with”, and reads them offline. No account, no ads, and your files stay on your phone.
