Newbie Trying to open MS Access file

Discuss the database features

Newbie Trying to open MS Access file

Postby Marchie69 » Mon Nov 30, 2020 2:10 pm

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
Marchie69
 
Posts: 1
Joined: Mon Nov 30, 2020 1:56 pm

Re: Newbie Trying to open MS Access file

Postby Hagar Delest » Mon Nov 30, 2020 2:35 pm

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.1 on Xubuntu 21.04 and 7.2.1 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 29983
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Newbie Trying to open MS Access file

Postby Villeroy » Mon Nov 30, 2020 2:44 pm

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
User avatar
Villeroy
Volunteer
 
Posts: 30167
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests