[Tutorial] MS Access and OOo Base
Posted: Thu Dec 03, 2009 2:57 pm
You can not open MSA .mdb or accdb files with Base, but you could connect to it, only on MS operation sytems.
(Base can not be connected to other MSA file types such as mde, mdt, accdt, accde etc.)
On linux you can use mdb-tools for connection to mdb files, but it can lost data, and the driver development is ceased.
On OS X you can try same mdb-tools, same warning as in linux case can loss data.
New>File> Database select third option connect to existing database, from drop down list select "Microsoft Access" for mdb, or "Microsoft Access 2007" for accdb files and finish.
You can reach only tables, queries, the forms, reports and coding not usable, needs to create from scratch.
More detailed description on OOo wiki:
MSA-Base Faq
Connecting to Microsoft Access
Useful posts you can find this forum if you use search facility with access keyword.
The two most useful:
Base Vs MS Access ?
[Solved] I can't get an Access file to open with Base
(Base can not be connected to other MSA file types such as mde, mdt, accdt, accde etc.)
On linux you can use mdb-tools for connection to mdb files, but it can lost data, and the driver development is ceased.
On OS X you can try same mdb-tools, same warning as in linux case can loss data.
New>File> Database select third option connect to existing database, from drop down list select "Microsoft Access" for mdb, or "Microsoft Access 2007" for accdb files and finish.
You can reach only tables, queries, the forms, reports and coding not usable, needs to create from scratch.
More detailed description on OOo wiki:
MSA-Base Faq
Connecting to Microsoft Access
Useful posts you can find this forum if you use search facility with access keyword.
The two most useful:
Base Vs MS Access ?
[Solved] I can't get an Access file to open with Base