Can AOO open MS ACCESS files?

["WA.TWORSX via AOL" <wa...@verizon.net.INVALID>]

Hello:

I've got several files that have either ".LDB" or ".MDB" file extension 
names.   I believe these files were generated with MS ACCESS vers 1.0. 
Can they be opened/used by AOO?

Regards,
VinceB.

Re: Can AOO open MS ACCESS files?

[Brian Barker <b....@btinternet.com.INVALID>]

At 11:44 12/04/2021 -0400, Vince Bonly wrote:
>I've got several files that have either ".LDB" or ".MDB" file 
>extension names. I believe these files were generated with MS ACCESS vers 1.0.

The .mdb files will indeed be Microsoft database files. The .ldb 
files are lock files used by Microsoft Access, so you can ignore those.

>Can they be opened/used by AOO?

I think not. But what you can do is to connect to the .mdb file, so 
as to have access to its data:
o In Step 1 of the Database Wizard, select "Connect to an existing database".
o From the drop-down menu, select Microsoft Access.
o Next >>.
o In Step 2, browse to and open the connection.
o Save your *new* database.
o See the original tables now accessible in your new database.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org