Microsoft Access Free Online MDB and ACCDB Viewer

No Access. No Java. No ODBC. No Windows. The database opens in this browser tab.

Stays on your computerNo accountSQL includedJoin across filesER diagram
SELECT p.Name, sum(o.Quantity) AS units
FROM sales.Orders o
JOIN catalog.Products p
  USING (ProductID)
GROUP BY 1

Query tables from several Access files at once

Each opened database becomes a schema named after its file, so sales.accdb and catalog.mdb join in one query. The SQL tab speaks DuckDB's SQL rather than Access SQL, and export writes a result as CSV, JSON or Parquet.

What it can do, and where it stops

What it reads out of an Access database

Each table is loaded with the type its column has in Access, so values read the way Access shows them:

  • Tables with their row counts; Access system tables stay hidden
  • Every column with its Access type: Short Text, Long Text, Number, Currency, Date/Time, Yes/No, AutoNumber, OLE Object
  • Currency and Decimal as exact decimals, Date/Time sorted in time order, Yes/No as true and false
  • Relationships drawn as an ER diagram
  • Saved select queries shown as SQL text, to read rather than run
  • Linked tables named, since their rows live in another file

Forms, reports, macros and VBA modules are not shown.

Nothing leaves the tab

The file is opened from your disk and read where it sits, so there is no upload and no copy on a server. Queries are read-only, which means the file you opened is the file you still have, and closing the tab leaves nothing behind.

Common questions

Does the database or its password leave my computer?

No. The whole file is read into this browser tab's memory and queried there, and a password you type is used in the tab to decrypt the file and is not stored or sent anywhere. Closing the tab discards both.

Which Access versions does it open?

Access 97 through Access 2019: .mdb files from the Jet 3 and Jet 4 engines, and .accdb files from ACE. A file that is not an Access database, or is damaged, is reported as such rather than shown empty.

Can it open a password-protected database?

Yes. An .accdb file encrypted with a password in Access 2007 or later asks for it in the page, and a wrong password is refused with a message so you can try again. An Access 2000-2003 database password does not encrypt the file, so such an .mdb opens without asking.

How large a database can it open?

There is no fixed limit: the file and a typed copy of every table are held in the tab's memory, so the machine sets the ceiling, and files over 1 GB get a warning. A query returns at most 10,000 rows, and an export writes the same result.

Can I edit the database?

No. The viewer runs SELECT and WITH queries only and never writes to the .mdb or .accdb file, so the file you opened is unchanged. To take the data elsewhere, export a result as CSV, JSON or Parquet.

From one file to a complete data workflow

Moving off Access rather than looking inside it? DBConvert's desktop tools convert Access databases to MySQL, PostgreSQL, SQL Server, Oracle, SQLite and Firebird.

Explore Access conversion

Need help with a file? Contact us