I’m setting up my first database using LO v 6.1.2.1 in Windows 10. I have chosen to use Firebird because this is being recommended for new databases.
I have set up tables and queries, and used the wizard to set up a form with a subform. All going well.
I then decided to add an additional field to the table. When I try to add this field to my form (the main form) the mouse cursor turns into a rotating disc and nothing further happens. When I close the form it crashes the database and all the data and design I have been doing since I opened the database is lost.
This happens whether I use a computer with Win 7 or Win 10. I have tried to run LO Base on an Ubuntu PC but won’t accept the Java SE and won’t run. But that’s another story!
Two questions please:
Is there a way of stopping the freezing happening?
If not, I have read that separating the back end can help. I can see lots of information about doing this with HSQLDB but not with Firebird. How do I do this please?
Thanks for your advice.