Does Base recognize .mdb files?

Discuss the database features
Post Reply
TJK60
Posts: 1
Joined: Sun Aug 26, 2012 9:33 pm

Does Base recognize .mdb files?

Post by TJK60 »

I recently assumed management of an organizational database. The previous keeper used Microsoft Office. The file he gave me was saved in .mdb format. I try to open it with OpenOffice Base 3.4. It only views the file in "all files" format and refuses to open it without trying to route it through Office Writer.

Doesn't base recognize the .mdb file format?
Open Office 3.4 for Windows 7 64-bit
FJCC
Moderator
Posts: 9549
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Does Base recognize .mdb files?

Post by FJCC »

You can connect to mbd files from a Base file. There is a tutorial: MS Access and OOo Base
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
eremmel
Posts: 1080
Joined: Tue Dec 30, 2008 1:15 am

Re: Does Base recognize .mdb files?

Post by eremmel »

Note for W7 64-bit: When you like to access your ms access via ODBC, you have to configure ODBC via C:\Windows\SysWOW64\odbcad32.exe. (Using Start -> Computer Control -> Administrative Tools -> Data Sources (ODBC) opens the 64bit where as OO / LO is 32-bit)
It's Microsoft marketing that tells you computers are qualified for non-technicians
W11 22H2 (build 22621), LO 7.4.2.3(x64)
Post Reply