JetBrains IDE plugin

MDB & ACCDB Database Viewer

Click an .mdb or .accdb file and see every table. Rows, column types, the SQL of every query, linked tables and relationships, with CSV export. On Windows, macOS and Linux, with no Access and no ODBC driver.

Get it on JetBrains Marketplace

Free trial with every feature.

An Access database open in an editor tab: the list of tables on the left and the rows of one table with the Access type under every column name

What you get

The rows of an Access table with the column names and their Access types

Every table, straight away

The tables and their row counts on the left, the rows on the right with each column's Access type. Find a value, copy cells, or save every row with Export CSV.

The SQL of a saved Access query shown in the tab

The SQL of every query

Saved queries are listed with their type. Click one to read its SQL and copy it into a migration or a new query.

The tab asking for the password of a protected Access database

Password-protected files

The tab asks for the password before it shows anything, as Access does. Encrypted files from Access 2007 and later open the same way.

What it shows

Tables and rows

Short Text, Long Integer, Currency, Date/Time, Yes/No, Long Text, calculated fields and multiple-value fields, shown as text you can read and copy.

Queries

Select, update, append, delete, crosstab and union queries, with their SQL. A password written into a query's connection to another database is hidden.

Linked tables and relationships

Where each linked table points, and which columns join which tables. For an ODBC link only the data source name is shown, never the user name or password.

Attachments and OLE objects

Double-click the cell to save what it holds: each file kept in an attachment field, such as a photo or a PDF, or the content embedded in an OLE object.

How to use it

  1. Install MDB & ACCDB Database Viewer from Settings | Plugins | Marketplace.
  2. Click an .mdb or .accdb file in the Project view. It opens in an editor tab on the first table.
  3. Click a table, a query, the linked tables or the relationships in the list on the left.
  4. Type in Find in table and press Enter or F3 to jump from match to match in the rows shown. Select cells and copy them, or click Export CSV.

The file is opened read-only and is never changed. When it changes on disk, the tab shows the new content.

Questions

How do I open an .accdb or .mdb file without Microsoft Access?

Install MDB & ACCDB Database Viewer in IntelliJ IDEA, PyCharm, DataGrip or another JetBrains IDE from Settings | Plugins | Marketplace, then click the .accdb or .mdb file in the Project view. It opens in an editor tab with every table and its number of rows on the left; click a table to see its rows and the type of each column. Access, the Access Database Engine and an ODBC driver are not needed.

How do I open an Access database on a Mac or on Linux?

Microsoft Access runs only on Windows. MDB & ACCDB Database Viewer reads the file itself, so it opens .mdb and .accdb files on macOS and Linux the same way as on Windows, inside a JetBrains IDE.

How do I export an Access table to CSV?

Open the file, click the table and click Export CSV. Every row of the table is saved as a UTF-8 CSV file with the column names in the first line, ready for Excel, pandas or a database import. You can also select cells and copy them.

Can I see the SQL of the queries in an Access database?

Yes. The Queries list shows every saved query; click one to see its SQL, ready to copy into a migration or a new query. The queries are shown and not run.

Does it open password-protected Access databases?

Yes, when you know the password. The tab asks for the password before it shows anything, just as Access does, and files encrypted with a password in Access 2007 and later open the same way. The password is never saved: the tab keeps it only while it is open.

Does the viewer send my database anywhere?

No. The contents of the files you open stay on your computer. If an error occurs inside the plugin, the IDE may offer to send an error report to JetBrains Marketplace, as it does for other plugins.

Works in

IntelliJ IDEA, PyCharm, DataGrip, WebStorm, Rider, GoLand, PhpStorm, RubyMine, CLion and DataSpell, version 2025.2 and later, on Windows, macOS and Linux. Files from Access 97, 2000 and 2002-2003 (.mdb) and from Access 2007 to Access 2019 and Access in Microsoft 365 (.accdb) open.

Privacy

The contents of the files you open stay on your computer. If an error occurs inside the plugin, the IDE may offer to send an error report to JetBrains Marketplace. See the privacy policy.

Support

If something does not work as expected, or something you need from your Access files is missing, email contact@gramshift.com or open an issue at github.com/gramshiftofficial/jetbrains-plugins. We answer within 2 business days for problems that block your work and within 5 business days for anything else. The most requested additions go into the next versions.

Limits

The viewer shows the data; it does not change it. The grid lists the first 10,000 rows of a table and Export CSV writes all of them. Queries are shown as SQL and are not run. Forms, reports, macros and VBA modules are not shown. The data of a linked table lives in its source and is not shown here.

See what an Access file holds, on any computer you work on.

Get MDB & ACCDB Database Viewer