Leaving Airtable? Bring your bases to Artavolo, checked record by record. See how

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
Preparation

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.
Step by step

Moving from Microsoft Access in 5 steps

  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.
  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).
    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.
  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.

  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.
  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.
Words

Microsoft Access’s words in Artavolo

What each part of Microsoft Access becomes after the move.

In Microsoft AccessIn Artavolo
Database fileBase
TableTable
RecordRecord
FieldField
RelationshipLink field
QueryView with filters
FormInterface or form view
ReportInterface dashboard
Macro or VBA moduleAutomation
The result

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 AccessResult
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
Migration help

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.

Ask for a fixed quote
Questions

Moving from Microsoft Access: questions and answers

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

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.

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.

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

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.