Can I use Microsoft Access databases (.mdb) in Base?

Can I use Microsoft Access databases (.mdb) in Base?

On Windows: yes. You cannot open them directly via File → Open, but you can access the data therein. For this, you need an Open Document Base file (*.odb), which holds the connection information. For details, see Connecting to Microsoft Access.

You can modify the data in the tables, and you can add and remove records. You can create new tables, but you cannot alter the structure of existing tables.

Queries in MS Access are shown as views in the table container. You can use the query results, but you have no access to the underlying definitions, and you cannot alter them.

You cannot read MS Access forms or reports.