[Solved] Stand Alone Form and hiding the db container

Discuss the database features
Post Reply
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

[Solved] Stand Alone Form and hiding the db container

Post by gkick »

Stand Alone Forms and Hiding Base Container
No problems with Hyperlinks to open forms but how does one close the form calling the other form as there only is one Action within the properties box?
I am missing something - Frontend Backend approach less potential dataloss and reduced need for macros the frontend being stand alone forms. Thats fine, the database container is not visible from within Writer, however can easily be accessed via file open base ?
Guess one could change the odb s file attributes to hidden as a non foolproof bandage or is there another option?
Also attempting to eliminate macros where possible and wonder if there is a way to run update, delete, append and create queries without macro and without going to Tools SQL ?
Thanks for any ideas
Last edited by gkick on Fri Aug 16, 2019 8:28 am, edited 1 time in total.
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Stand Alone Form and hiding the db container

Post by Villeroy »

You have a backend database where you can set up privileges in SQL (keywords CREATE USER, CREATE GROUP, GRANT).
You have office documents as frontend which can be made read-only. The Base document stores the connection parameters and various definitions of queries, forms and reports but not a single byte of user data. You can write protect stand alone form documents as well. The form controls will work anyway since they write to the database rather than the containing document. If you use spreadsheet reports (like I do), these need to be writable because the imported data modify sheet cells.
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
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Stand Alone Form and hiding the db container

Post by gkick »

Thank you !
Libre Office 6.4.6 on Windows 10 HSQL 2.51 backend
Post Reply