Faq/Base/006

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

• FAQ Home
• General
• Writer
• Calc
• Impress
• Draw
• Math
• Base

I cannot access my MS Access database with LibreOffice. There are no data sources of this type available

Only the name and the syntax have changed.

• First of all you need the "Microsoft Jet Engine" to access your MS Access files. It's a part of the Microsoft Data Access Component, MDAC. Download the latest version and install it.
• Then go to Utils > Data sources and in the dialogue box create a new ADO data source, and in the URL enter

 PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=<filepath> 

When you have replaced <filepath> with the path to the file you will have something like "Data Source=C:\AllMyFiles\MaBDD.mdb"