CODEWITHSUNDEEP
ms-accessopenoffice-base
Matt
Matt

Reputation: 33

Is OO Base compatible with MSO Access?

Is Open Office Base compatible with MS Office Access? That is, can I successfully edit an Access-made database from Base?

Thanks

Upvotes: 1

Views: 2044

Answers (1)

Philippe Grondier
Philippe Grondier

Reputation: 11148

By opening oo base (version 3.3), the dialog box proposes to select a database and connect to an existing one. Among the available options, it is possible to connect directly to:

  • an Acces Database
  • an Access 2007 Database
  • an ODBC database
  • an ADO database

Though the "Acces Specific" connectors will allow you to transfer existing data from an Access database to a ooBase database, the more generic one (ODBC, ADO) can allow you to manipulate any ODBC\ADO compatible database, including Access. Though it is dated, you could refer to this oo version2 document, where there is an example of connecting from ooBase to Access through ADO

Upvotes: 1

Related Questions