Page 1 of 1

Newbie Trying to open MS Access file

PostPosted: Mon Nov 30, 2020 2:10 pm
by Marchie69
Hi I'm a new user of OpenOffice and having trouble opening a Microsoft Database.
I've watch a few Youtube videos on how to do this but keep geting an error
Any help would be great!

Re: Newbie Trying to open MS Access file

PostPosted: Mon Nov 30, 2020 2:35 pm
by Hagar Delest
Hi and welcome to the forum!

What kind of error? If you want us to help you, we need some details.
Please have a look at: Tips for a better description of the problem. The whole tutorial may help by the way. It may have been answered in the past.

Re: Newbie Trying to open MS Access file

PostPosted: Mon Nov 30, 2020 2:44 pm
by Villeroy
MS Access opens MS Access documents only. An MS Acccess doument may embed a MS JET database or it may be connected to a wide variety of external databases.
Base opens Base documents only. A Base doument may embed HSQL database or it may be connected to a wide variety of external databases.
Just like with MS Access, you create a new database document and connect it to some external database.
File>New>Database...
Connect to existing database
Type: MS Access
Specify your Access database
Save the database document.
---------------
Now you an use the MS Access database in the context of this office suite. You can add queries, forms and reports to the database document and you can export database data into OpenOffice documents. The forms and reports that have been created in MS Access are usable with MS Access only.