[Solved] Split Embedded

Discuss the database features
Post Reply
Mickey12
Posts: 75
Joined: Thu Apr 16, 2020 3:07 pm

[Solved] Split Embedded

Post by Mickey12 »

Hi I am wanting to convert my embedded base to a split base in order to allow two users over a lan.
There is lots of rather daunting material on these forums, some of which is 7 years old.
I am able to create a new split base called Split_HSQLDB_2.3_Wizard_v3d.odb
Can I just drag the tables,forms,queries from my embedded base to the split base?
Thanks
Last edited by Mickey12 on Wed Apr 29, 2020 9:05 am, edited 1 time in total.
Open Office 4.1.7 on Windows 10
Mickey12
Posts: 75
Joined: Thu Apr 16, 2020 3:07 pm

Re: Split Embedded

Post by Mickey12 »

Ok, somehow I got this right. Not sure how. As I am unable to detail the steps I don't think it should have a solved tag. In case someone else queries this.
Open Office 4.1.7 on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Split Embedded

Post by Villeroy »

[Python] Macro to extract and reconnect embedded HSQLDB
Backup your database file (just in case)
Create a directory where you put the right hsqldb.jar
Install the macro (one click).
Open your Base with embedded HSQL.
Call the macro. It converts your existing document.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Mickey12
Posts: 75
Joined: Thu Apr 16, 2020 3:07 pm

Re: Split Embedded

Post by Mickey12 »

Wow! Thanks
Open Office 4.1.7 on Windows 10
Mickey12
Posts: 75
Joined: Thu Apr 16, 2020 3:07 pm

Re: [Solved] Split Embedded

Post by Mickey12 »

Ok so I am guessing that converting my embedded database to a split database is the reason why I now cannot edit any of the tables?
Open Office 4.1.7 on Windows 10
Mickey12
Posts: 75
Joined: Thu Apr 16, 2020 3:07 pm

Re: [Solved] Split Embedded

Post by Mickey12 »

The answer is yes. There are options available.
Open Office 4.1.7 on Windows 10
Post Reply