MDB & ACCDB Viewer

Help

Which files work?

Microsoft Access databases from Access 97 to Access 2019 and Microsoft 365: .mdb (Access 97–2003) and .accdb (Access 2007 and later). Compiled .mde and .accde files and runtime .accdr files store their tables the same way and usually open too. There is no file size limit in the app itself; very large files (several hundred MB) need a desktop browser with enough free memory.

How do I open a database from Google Drive™?

Install the app from the Google Workspace™ Marketplace. In Drive, right-click the .mdb or .accdb file, choose Open with → MDB & ACCDB Viewer, then click Open the database from Google Drive and allow access to that file.

Finding data

Pick a table on the left. Type in Search this table to filter rows (all columns, or choose one column). Click a column header to sort, click again to reverse, a third time to clear. Drag a header edge to resize a column; double-click it to fit the content. Click a row to see the whole record, including long text and attachments. Use ↑ and ↓ to move between records.

Design, relationships and saved queries

Design lists every field with its Access data type and size. Relationships shows how tables are linked and whether integrity is enforced. Saved queries are listed under the tables; click one to see its SQL. With Pro, select queries can be run in the SQL tab. Action queries (update, delete, append, make-table) are shown but never run: the viewer never changes your database.

About the SQL console (Pro)

Queries run on a temporary copy of the tables inside your browser, using SQLite. Common Access syntax is translated ([brackets], &, #dates#, True/False, TOP n, IIf, Nz). Some Access-only functions and parameter queries won't run. Results show the first 5,000 rows; Result → CSV saves them all.

Exporting (Pro)

Export the current table (including your search and sort) to Excel, CSV or a new Google Sheet, or the whole database to one Excel workbook or a ZIP of CSV files. Tables with more than 1,048,576 rows continue on extra sheets. Google Sheets holds up to 10 million cells; use Excel or CSV for bigger tables. Saving to Google Sheets asks for permission to create that one file in your Drive.

Password-protected databases

If the owner set a database password, the app asks for it. The password is used only in your browser and is not saved. The app does not guess or remove passwords.

Linked tables

A linked table only points to data in another file (another Access database, Excel, or a SQL server). The app lists linked tables but can't show their data. Open the source file instead.

"The database could not be read"

The file may be damaged, still being written, or use a feature we don't support yet. Lock files (.ldb, .laccdb) are not databases; open the .mdb or .accdb next to them. Email the Access version that saved the file to mdb@lrlr-master.com (please don't attach confidential data).

Is my database uploaded?

No. It is read inside your browser and never sent to our servers. See the privacy policy.

Free plan and Pro

Viewing is free, with no pop-ups and no account. Databases up to 40 MB open completely; for bigger ones the free plan shows the first 1,000 rows of each table plus the full design, relationships and saved queries. Pro ($4.99 a month or $29 once) adds export, the SQL console and full access to large databases. Everything is unlocked on the sample database. On your own files you also get 5 free trial uses: each export uses one, and the SQL console or opening every row of a large database uses one per file. Files made during the trial have "free-trial" in their name and a short note inside. The page is available in 24 languages; pick yours at the top.

Licenses and refunds

Paste the key from your receipt email into Upgrade. One key works on up to 5 browsers. To cancel a monthly plan, use the "Manage subscription" link in your receipt email. If the app can't open your database, we refund within 14 days of purchase.

© 엘알엘알 (LRLR), Republic of Korea · Business details · Privacy Policy · Terms of Service · Help · Support: mdb@lrlr-master.com
Google Drive™, Google Sheets™ and Google Workspace™ are trademarks of Google LLC. MDB & ACCDB Viewer is not affiliated with or endorsed by Google LLC or Microsoft.