Hide database "backend" from the final user

English
, ,
#1

Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR
Calc: threaded

Morning everyone, I was wondering if there’s a way that I could hide the backend from the database, meaning the tables, and queries and other stuff that the final user shouldn’t have acces.

Since I’m building an “application” for an user that is not me, I think it would help me a lot to keep the database safe if this can be done.

Thanks.

#2

https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=77543

The “FreeForms” macro extracts all form documents.
For the report, you may try BaseReportExtension » Extensions) or Apache OpenOffice Community Forum - [Writer] Stand-Alone Database Reports - (View topic)

#3

Ok, I got how to run it, but how can I get the HSQLDB file?

#4

Ignore the “FreeHSQLDB” macro. The “FreeForms” macro has nothing to do with HSQL. It extracts all form documents from any database document, reconnects the extracted forms with the database and flags the new documents read-only.

#5

When I try to run the Main macro inside FreeForms I get an error on BASIC, saying that it has not found the getImplementationName method. How to fix it?

It wasn’t happening before my lunch break, but now it is

Sometimes it hits me with the message that the macro only works for *.odb databases, even though I’m using a .odb database

#6

This used to work for many years. I give up on this bloody macro shit.

  1. Open one form and save it as a Writer document.
  2. Open the saved document, turn on form edit mode and the form navigator.
  3. For each form and subform in that form navigator
    3.1. Copy the “Source” property
    3.2. Specify the database and the source type. This resets the “Source” property.
    3.3. Paste back the “Source” property.
  4. Call menu:File>Properties… Tab "Security and check “Open read-only”.
  5. Save the document
  6. Test the document
  7. Repeat for each form that you want to be used without Base document.
1 Like
#7

Open the database document in question before running the macro.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.