[Solved] Stand Alone Form and hiding the db container

Discuss the database features

[Solved] Stand Alone Form and hiding the db container

Postby gkick » Thu Aug 15, 2019 10:10 am

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.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 245
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: Stand Alone Form and hiding the db container

Postby Villeroy » Thu Aug 15, 2019 10:56 pm

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, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28422
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Stand Alone Form and hiding the db container

Postby gkick » Fri Aug 16, 2019 12:29 am

Thank you !
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 245
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile


Return to Base

Who is online

Users browsing this forum: No registered users and 6 guests