Newbie Trying to open MS Access file

Discuss the database features
Post Reply
Marchie69
Posts: 1
Joined: Mon Nov 30, 2020 1:56 pm

Newbie Trying to open MS Access file

Post 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!
OpenOffice 4.1.8 on Window 10
User avatar
Hagar Delest
Moderator
Posts: 30690
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Newbie Trying to open MS Access file

Post 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.
LibreOffice 7.2.6 on Xubuntu 22.04 and 7.2.6 portable on Windows 10
User avatar
Villeroy
Volunteer
Posts: 30801
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Newbie Trying to open MS Access file

Post 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.
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
Post Reply