I know this can be done, but I require the Queries and Reports to be displayed under Queries, and Reports - not all under Tables.
Is this possible ?
I'd like to move away from Micro$oft, and currently use as much open source as I can.
I use Windows XP (sp3).
Importing an entire MSAccess db in one go
Re: Importing an entire MSAccess db in one go
No application other than Microsoft Access can read mdb files. Even if OOo could do that there would be no real equivalent to forms and reports. Forms and reports in Base are embedded Writer documents. They are by far less sophisticated than forms and reports in Access. When some database frontend imports data from some database backend, it uses some driver which can serve the resulting recordsets of SELECT-queries. Sometimes the driver can update, insert and delete as well. This is exactly the same when you import any foreign database (e.g. MySQL) into a MSAccess frontend. You install a driver, register an odbc datasource and connect Access to the datasource. Then you define queries, forms and reports with the built-in tools of the MSAccess frontend.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice