When I had MS Office 2010, I was able to use ‘Access’ to edit a file from a vendor product. How may I use LibreOffice to do the same edits? Thank you!
Depends.
-
Is it really a database of Access, or did Access connect to another Datasource?
-
Are you on Windows? It has some components to access Access-data integrated.
-
For Access there were 2 Versions of databases, if I’m remembering right.
-
For Password-protected databases it may be necessary to remove the password before you can access data - depending on your OS/database-driver etc.
Maybe the easiest is to extract data with Access and re-build the database in LibreOffice. Only Access will give you the old forms you used. All connectors/drivers etc will usually only extract data, not forms, queries etc.
.
But first step: Find out more than ‘Once upon a time I used Access…’ if you seek help.
.
Maybe you are lucky and your database is actually csv or dbase, wich can be handled directly with Base or even Calc, but ‘vendor’ also doesn’t give much info.
If running a Windows system:
menu:File>New>Database…
Connect to existing db
Type: Access
Point to your Access document.
Yes, register the database (make it accessible to office documents)
Save the database document.
This does not import, copy, convert anything. Your data are still in the Access document unless that document is linked to something else. In case of a self-contained Access database, you should see the tables. Access queries are imported as views. At this point you may add your own queries, forms and reports to to the Base document. If you registered the database, several features allow you to import data into Writer and Calc.
There is also a free driver that works with all operating systems. This requires some installation and configuration.
The other driver I know of is UCanAccess. Link to Windows instructions are here → Importing an Access database from Office 2010
Villeroys method works (to my testing) only for Access-database without password.
Password-protected ones may be accessible through ODBC
as noted in the following old german link, but I have to retreive a database with password for this before I can try.
http://www.oooforum.de/viewtopic.php?t=37002
.
Update: Seems to work with odbc. When the tables or queries are accessed I was asked for Username/password. But as it turned out this file only connected to another .mdb without password there may be other obstacles lurking. But I could connect from a Win10 21H2, wich never touched any MS-Office.