I have an MS Access database that I need to make functional in both Windows and Mac. I see I can “connect” the database to Base and then save it as a Base database but when I do this, all queries and tables are lumped together in Tables and no forms are transferred over. How do I separate all of this out and transfer the forms and reports over? The MS Access DB is created in 2013. I tried connecting as both Access 2007 and as a .mdb file and both have the same problem.
In LO you can connect to an MS Access Database and view the Tables or copy them into a Base database. You cannot view or copy any other components of the Access Database. You will need to create these components from scratch in Base.
Thank you for the reply. Why did my queries transfer in with the tables? They are all under the tables heading and I cannot put them into the queries heading. Does this matter? or will they work as normal?
@usaemtp I have only connected to an Access DB file containing only Tables. I have seen this - “MS queries are handled as views in OOo and shown in the table container.” This looks like what you are getting.