Attach Tables From A "Backend" Database.odb

[James_Zimmerman]

Using Microsoft Access we were able to create a “Front-end” database, containing all of the logic, and a “Back-end” database containing just tables. We connected the “Back-end” tables to the “Front-end” database and delivered the pair of database files to the customer. Then when an update to the front end was needed we only needed to give them that new database file and all of the customer’s data was not over-written.

I don’t remember whether we needed ODBC for this, but it seems like it should not be necessary.

Does anybody know how to do this in LibreOffice?

[Ratslinger]

Hello,

There is nothing built into Base to do that. There are existing methods using a newer version of HSQLDB or an external Firebird database. I would avoid (except for testing & demo purposes) the HSQLDB embedded - it is very old and prone to problems (like losing data) at times.

See links in this post > Split data from application