Ask Your Question
0

Can I open MS Access forms in base

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 close merge delete

2 Answers

Sort by » oldest newest most voted
0

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
0

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

Comments

@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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 1,031 times

Last updated: Jan 25 '16