When connection is finished, you see your chosen connection on the left side in the status bar. The next steps depend on the chosen kind of connection. You can use Microsoft Access, ADO, or ODBC. In the first step select Connect to an existing database. Start wizard with File ▸ New ▸ Database or use item LibreOffice Base from Windows (German) Startmenü, or use item Database in LibreOffice Quickstarter. Even in WinXP those file are not included automatically. Searching for AccessDatabaseEngine (without spaces) in the Microsoft download center will lead you to the download link. For ACCDB files you might need “ 2007 Office System Driver: Data Connectivity Components”. You might need “Jet 4.0 Service Pack” and “Microsoft Data Access Components (MDAC)”. Win98) might not include all needed files for handling MDB-files. On one hand ACCDB doesn't know user based security, on the other hand you can work with attachments inside the database file, for example.īoth versions can be controlled with “ODBC driver” or with “ OLE DB Provider”. The two versions (the former and the latter) are not compatible. The latter uses a modified Jet database engine, called “Access Database Engine” (ACE). Starting with MS Access 2007 (Office 12), Microsoft Access has begun to use the new file type ACCDB. It can be handled with the database engine “Jet 4.0”. The file type MDB has been used by versions of Microsoft Access, from Access 97 (Office 8) up to Access 2003 (Office 11).

This description has been tested on WinXP Home, for other Windows versions it might work a little differently.

4 Setup User Authentication (Wizard Step 3).

How do i check mdac version?