[Solved] Problem with making split database fully portable
Posted: Sun Nov 02, 2014 10:50 pm
As club secretary after I took over I changed from paper documentation to OpenOffice/Libreoffice and developed a database with several tables, many queries, several linked forms (using macros) and reports. Now has come the time to pass this all on to my successor.
Using the instructions in this forum (viewtopic.php?f=83&t=61183) I tried to put my split-database completely on a USB-stick.
At opening and using the method described above, the best I could get was successful transfer (from the original db to a new one) of tables, queries, forms and reports (rather cumbersome as each item needed to be dragged from the original db to the new one). However, the transfer of the macros was not successful. In fact, I had to enter them again (OK copy/paste worked, but this is very unsatisfactory)
As I have another 6 months before transferring everything to my successor, the urgency is manageable.
Nevertheless, I would greatly prefer to do it simply.
I am running Linux Fedora20
In the bottom line of the db window is the text:
JDBC hsqldb:file:/home/name/.../members;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
NB: the new, empty database made according to the recipe in the internet link given above gave in the bottom line the new path name /media/.../mydb (on the USB-stick)
It seems that simply changing the path name as it appears in the bottom line would be the best, but I have no idea how to do that.
I hope someone has an easy solution!
Bananiel-1944
Using the instructions in this forum (viewtopic.php?f=83&t=61183) I tried to put my split-database completely on a USB-stick.
At opening and using the method described above, the best I could get was successful transfer (from the original db to a new one) of tables, queries, forms and reports (rather cumbersome as each item needed to be dragged from the original db to the new one). However, the transfer of the macros was not successful. In fact, I had to enter them again (OK copy/paste worked, but this is very unsatisfactory)
As I have another 6 months before transferring everything to my successor, the urgency is manageable.
Nevertheless, I would greatly prefer to do it simply.
I am running Linux Fedora20
In the bottom line of the db window is the text:
JDBC hsqldb:file:/home/name/.../members;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false
NB: the new, empty database made according to the recipe in the internet link given above gave in the bottom line the new path name /media/.../mydb (on the USB-stick)
It seems that simply changing the path name as it appears in the bottom line would be the best, but I have no idea how to do that.
I hope someone has an easy solution!
Bananiel-1944