Access Viewer: Complete Feature Guide & Reference
🗂️ Open the Access Viewer to explore every feature described in this guide.
Open Access Viewer →Contents
What Is the Access Viewer?
The FinancialDataTools.com Access Viewer is a free, browser-based tool for opening and exploring Microsoft Access database files. It reads your .mdb and .accdb files entirely inside your browser — no file is ever transmitted to any server.
The viewer is designed for financial analysts, accountants, and business users who work with legacy Access databases — from accounting system exports to CRM data stores to historical business records that have never been migrated to a modern format.
Try the Access Viewer — runs entirely in your browser and never uploads your files.
Open the Access Viewer →Supported File Formats
The viewer supports both major Microsoft Access database formats:
| Extension | Format | Common Source |
|---|---|---|
| .mdb | Access 97–2003 format | Legacy business applications, older accounting software |
| .accdb | Access 2007 and later | Modern Access databases, CRM exports, reporting databases |
Note: Password-protected Access databases are not currently supported. The viewer reads standard, unencrypted Access files only.
The Toolbar
The toolbar runs across the top of the viewer and provides all primary actions:
| Button | Function |
|---|---|
| Open File | Opens a system file picker to select your .mdb or .accdb file |
| Schema | Opens the column definition modal for the active table |
| Export | Opens the export dialog for the active table |
| File name display | Shows the currently loaded database file name |
| Search box | Global text search across all visible columns in the current table |
Table Browser
When a database is loaded, the tab bar below the toolbar displays a tab for each table found in the Access file. Clicking a tab loads that table's records into the main data grid.
The stats bar below the tab bar shows three key numbers at all times: the total record count, the number of records currently showing (after filters), and the column count. This updates in real time as you apply or remove filters.
Sorting Columns
Click any column header to sort the table by that column. The first click sorts ascending (A–Z, smallest to largest), the second click sorts descending, and a third click returns to the original order. A small arrow indicator in the header shows the current sort direction.
Sorting works across the entire loaded dataset, so it correctly ranks values even across large tables with many records.
Row Filtering
Each column header contains a filter icon (funnel) that opens an advanced filter panel for that column. The filter panel has two modes:
- Values mode: Shows a checklist of all distinct values in that column. Uncheck values to hide rows containing them. A search box inside the filter panel lets you quickly find specific values in long lists.
- Conditions mode: Apply up to two custom conditions using operators including contains, equals, does not equal, begins with, ends with, greater than, less than, is empty, and is not empty. Combine two conditions with AND or OR logic.
Multiple column filters stack with AND logic — a record must satisfy every active filter to remain visible. A pink badge in the stats bar shows the number of active column filters and can be clicked to clear them all at once.
Global Search
The search input in the toolbar performs a global text search across all columns of the currently active table simultaneously. This is useful when you know a value exists in the table but are unsure which column contains it. Results update as you type.
Global search works in combination with column filters — both conditions must be satisfied for a record to remain visible.
Schema Inspector
Click the Schema button in the toolbar to open the column definition modal for the active table. This shows:
- Column names
- Access data types (Text, Number, Date/Time, Boolean, OLE Object, etc.)
- Field size (character limit or byte size)
- Nullable status
You can copy the full column list as plain text using the Copy Column List button in the modal — useful for documentation or when mapping an Access schema to a target database or spreadsheet.
Pagination
Tables with more than 50,000 records are automatically paginated to 5,000 records per page. The page bar at the bottom of the grid shows the current page, total pages, and the absolute record range being displayed. Navigation buttons — First, Previous, Next, Last — let you move through pages quickly.
A pagination badge appears in the stats bar when you are viewing a paginated table, so you always know whether you are seeing the full dataset or one page of it.
Export Options
Click the Export button in the toolbar to open the export dialog. Four formats are available:
| Format | Best For | Notes |
|---|---|---|
| CSV | Spreadsheets, Python/pandas, data pipelines | UTF-8 encoded; NULL values exported as empty strings |
| JSON | APIs, JavaScript, data processing | Array of objects; column names as keys; preserves null |
| Excel (.xlsx) | Sharing with non-technical stakeholders | Frozen header row; auto-sized columns; includes attribution sheet |
| TSV | Tab-separated import targets | Tab-delimited; useful when values may contain commas |
Two export scopes are available: Filtered view exports only the records currently visible after applying search and filters, and Full table exports all records ignoring any active filters. The multi-table workbook export (Excel only) exports every table to a single .xlsx file with one worksheet per table.
Privacy & Security
The Access Viewer is built privacy-first. Your database file is never uploaded to any server. The entire file is read using JavaScript running inside your browser tab. There is no server component receiving your data — the only network requests are to load the viewer tool itself.
This makes the viewer appropriate for sensitive financial data including:
- Legacy accounting system databases stored in Access format
- CRM records and client financial data
- Business reporting databases with proprietary data
- Historical financial records that have never been migrated to a modern system
Closing the browser tab clears all data from memory immediately. No data is written to localStorage or any persistent browser storage.
Use Cases for Financial Data
Microsoft Access was widely adopted in accounting, finance, and business operations during the 1990s and 2000s, and many organizations still maintain active Access databases or have archives of historical data in this format. Common scenarios where the viewer adds immediate value:
- Legacy accounting databases: Small businesses that used Access-based accounting systems — such as custom-built ledger or invoicing applications — can now open and export their financial records without needing Microsoft Access installed.
- CRM and client records: Many financial advisors and small brokerages built client relationship databases in Access. The viewer lets you inspect these records and migrate them to modern formats like CSV or Excel.
- Reporting databases: Finance departments that generated reports from Access queries can re-examine the underlying data tables without needing to maintain a legacy Access installation.
- Data migration projects: When migrating from Access to SQL Server, PostgreSQL, or another system, the viewer helps you audit table structures and record counts before and after migration.
- Archival analysis: Historical financial records stored in Access files from decades-old business systems can be opened, browsed, and exported to modern formats without installing any software.