Ask Your Question

Can I open MS Access forms in base [closed]

asked 2016-01-25 07:48:46 +0100

usaemtp gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-29 11:44:20.772656

2 Answers

Sort by » oldest newest most voted

answered 2016-01-25 15:55:37 +0100

peterwt gravatar image

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.

edit flag offensive delete link more

answered 2016-01-25 17:26:32 +0100

usaemtp gravatar image

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?

edit flag offensive delete link more


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

peterwt gravatar imagepeterwt ( 2016-01-26 22:53:02 +0100 )edit

Question Tools

1 follower


Asked: 2016-01-25 07:48:46 +0100

Seen: 1,174 times

Last updated: Jan 25 '16