How to move from Microsoft Access to Artavolo
A step-by-step guide: what to export from Microsoft Access, how to bring it in, what comes over, what you rebuild, and how to check the result.
Last reviewed
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 export
- The database file itself: .mdb or .accdb
- You import with
- Import data, then Access
- It costs
- Nothing: the importer is free
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
-
Export from Microsoft Access
You get: The database file itself: .mdb or .accdb.
- Close Access, and copy the .mdb or .accdb file (from the shared drive, say).
- If it has a database password, have it ready: the import asks for it.
- Linked tables live in other files: bring those files too.
-
Bring the files into Artavolo
The files are read in your browser.
- In Artavolo, choose Import data on Home, then Access (this link opens it for you).
- Pick the database file. If it has a password, type it.
- 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.
-
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.
-
Check the new base
- Compare the number of records in each table with Microsoft Access.
- Open a few records and check their links, dates and selects.
- Read the count of records whose parent is gone: the report lists them per relationship.
- Go through the report’s list of what is different, and decide what to rebuild.
-
Rebuild and switch over
- Rebuild what the export leaves out: the table below lists it, and so does the import report.
- Invite the team, and set who sees which tables and records.
- 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
What each part of Microsoft Access becomes after the move.
| In Microsoft Access | In Artavolo |
|---|---|
| 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, and what you rebuild
The import report names every item in the second group, so nothing is dropped without a word.
| From Microsoft Access | Result |
|---|---|
| Every table, from Access 97 to 2019 | Comes over |
| Relationships as links between tables | Comes over |
| AutoNumber, Currency, Yes/No, Date/Time, Memo and Hyperlink fields typed as such | Comes over |
| Attachment fields with their files | Comes over |
| Forms (as interfaces and form views) | You rebuild |
| Reports (as dashboards) | You rebuild |
| Queries (as views), macros and VBA (as automations): the report lists every one by name | You rebuild |
Rather we did 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. We run the import, rebuild what the export leaves out, check the result against the report with you, and walk you through it on a recording.
Tell us what you use in Microsoft Access and roughly how much data; we answer with a price within one business day.