# How to move from Microsoft Access to Artavolo.com

> You bring the .mdb or .accdb file itself, Access 97 to 2019, with its password if it has one, and it is read in your browser. Every table comes over, relationships become links, and AutoNumber, Currency, Yes/No, Date/Time, Memo, Hyperlink and Attachment fields keep their types, attachments with their files. Forms, reports, queries, macros and VBA are rebuilt as interfaces, views and automations; the report lists every one by name. The file is not changed.

Source: https://artavolo.com/migrate/access
Last reviewed: 16 November 2026

## In short

You bring the .mdb or .accdb file itself, Access 97 to 2019, with its password if it has one, and it is read in your browser. Every table comes over, relationships become links, and AutoNumber, Currency, Yes/No, Date/Time, Memo, Hyperlink and Attachment fields keep their types, attachments with their files. Forms, reports, queries, macros and VBA are rebuilt as interfaces, views and automations; the report lists every one by name. The file is not changed.

You import with: Import data, then Access.

## Before you start

- Copy the file while Access is closed.
- Have the database password ready, if there is one.
- Find the files that hold any linked tables, and bring them too.
- Make a free Artavolo account and a workspace: the free plan has no limit on people or records.
- Keep Microsoft Access running. Nothing in it changes, and the team switches once the new base is checked.

## Moving from Microsoft Access in 5 steps

### Step 1: Export from Microsoft Access

You get: The database file itself: .mdb or .accdb.

1. Close Access, and copy the .mdb or .accdb file (from the shared drive, say).
2. If it has a database password, have it ready: the import asks for it.
3. Linked tables live in other files: bring those files too.

### Step 2: Bring the files into Artavolo

The files are read in your browser.

1. In Artavolo, choose **Import data** on Home, then **Access** ([this link opens it for you](https://artavolo.com/login?then=%2F%3Fimport%3Daccess#sign-up)).
2. Pick the database file. If it has a password, type it.
3. The tables and their fields are shown with their types, and what was found (links, lookups, groups). Untick a table to leave it out, then choose **Make the base**.

### Step 3: Read the import report

It lists the tables and records made, the formulas and lookups checked against Microsoft Access’s own results record by record, and what is different, so nothing is dropped without a word.

### Step 4: Check the new base

1. Compare the number of records in each table with Microsoft Access.
2. Open a few records and check their links, dates and selects.
3. Read the count of records whose parent is gone: the report lists them per relationship.
4. Go through the report’s list of what is different, and decide what to rebuild.

### Step 5: Rebuild and switch over

1. Rebuild what the export leaves out: the table below lists it, and so does the import report.
2. Invite the team, and set who sees which tables and records.
3. Set Microsoft Access to read-only, or stop using it, and keep it for a month rather than deleting it.

## Microsoft Access's words in Artavolo.com

| Microsoft Access | Artavolo.com |
| --- | --- |
| Database file | Base |
| Table | Table |
| Record | Record |
| Field | Field |
| Relationship | Link field |
| Query | View with filters |
| Form | Interface or form view |
| Report | Interface dashboard |
| Macro or VBA module | Automation |

## What comes over

- Every table, from Access 97 to 2019
- Relationships as links between tables
- AutoNumber, Currency, Yes/No, Date/Time, Memo and Hyperlink fields typed as such
- Attachment fields with their files

## What you rebuild

- Forms (as interfaces and form views)
- Reports (as dashboards)
- Queries (as views), macros and VBA (as automations): the report lists every one by name

## Help with the move

We move a base or a whole workspace from Microsoft Access for a fixed price, agreed before we start and quoted by e-mail: https://artavolo.com/contacts

## Questions and answers

### Our database is from Access 97. Will it open?

Yes: Access 97, 2000, 2003, 2007, 2010 and later, .mdb and .accdb, with database passwords. It is read in your browser.

### Do relationships survive?

Yes: each relationship becomes a link from the child table to the parent’s record (Orders.CustomerID becomes a Customer link), and records whose parent is gone are counted in the report.

### What about our forms and reports?

They are listed by name in the report, to rebuild as interfaces, form views and dashboards. In a fixed-price move we rebuild them for you.

### Does anything change in Microsoft Access?

No. You only export from Microsoft Access, and the files are read in your browser. Keep using it until the team has switched.

### Can you do the move for us?

Yes. We move a base or a whole workspace for a fixed price, agreed by e-mail before we start: we run the import, rebuild what the export leaves out and check the result against the report with you.

How Microsoft Access compares: https://artavolo.com/compare/access.md
