odb file is simply linked to an external, MSA-compatible, data source, particularly those offering an " ODBC" connection option, then MSA will ' Link to the data source by creating a linked table.' And you get full read/write access with the "ODBC" option. odb files generated by Base those with and those without an "embedded database." So if your Base. There's no way to to link to tables stored within a Base. You cannot read MS Access forms or reports.Ĭan I read my Base database from MS Access (MSA)? You can use the query results, but you have no access to the underlying definitions and you cannot alter them. Queries in MS Access are shown as views in the table container. You can create new tables, but you cannot alter the structure of existing tables. You can modify the data in the tables and you can add and remove records. For details see Microsoft Access or Connecting to Microsoft Access. For this, you need an Open Document Base file (*.odb), which holds the connection information. You cannot open them directly via File → Open, but you can access the data therein.
Openoffice base vba update#