Hi,
Now that i have designed my db i want to start using it, but ...
1) i don't really care for "design studio" to be loaded - i just want to see my main form (just like you can run an Access db as stand alone using the Access runtime)
2) i initially imported my data from an aCCESS DB, and when i examin the database > Properties for my table, it still point to the *.mdb file, and i can see that the 'last modified' time on this file is updated whenever i open my OO-base. Will i need the .mdb file always?
Thanks
Erik
[Solved] Run db stand alone?
[Solved] Run db stand alone?
Last edited by TheGurkha on Thu Sep 08, 2011 6:31 pm, edited 2 times in total.
Reason: tagged [Solved]
Reason: tagged [Solved]
OpenOffice 3.3.0 on Windows 7
Re: run db stand alone?
Hello
When you use an OOo form for your database then you have always to start OOo.
Romke
When you use an OOo form for your database then you have always to start OOo.
Romke
LibreOffice 7.1.4.2 on openSUSE Leap 15.2
Re: run db stand alone?
Hi Romke,
I see. I was hoping to be able to start sbase.exe with my database file as a command line parameter and then have my main form launched direcly.
Erik
I see. I was hoping to be able to start sbase.exe with my database file as a command line parameter and then have my main form launched direcly.
Erik
OpenOffice 3.3.0 on Windows 7
Re: run db stand alone?
Attaching all logical forms to stand-alone office documents can give you
quite a lot of advantages. You may also use the tabbed interface of Calc or
Draw for your input forms.
1) You get form documents that can be opend by means of simple desktop links
so you never see the database document.
2) The form documents or pages (sheets) in the same form documents can be
connected by means of hyperlinks (switch boards without coding macros).
3) You can protect the form documents from modification by means of document
protection or on file system level.
4) In the tabbed Calc interface you can elegantly mix input forms with
report sheets (enter invoice, print latest invoice, search invoice, also
without any coding). The layout and print capabilities of Calc are good
enough and it can easily do all sorts of calculation which are sometimes
more difficult to do in a database.
5) All Base features always refer to a single data source. In stand-alone
forms documents you can connect a form to a row set from database A and
build a relation through a subform connected to a row set from database B.
6) The bug which leads to the thread does not occur(copied from another thread)
Now for the only draw-back I'm aware of:
The Writer documents embedded in the Base document store their own settings
for window size, menu bars and view settings. When using stand-alone
documents for input forms, the initial window sizes and view settings are
the same as with any other documents of the same document type.
Step-by-step instructions on how to save an embedded Writer form as a
stand-alone Writer form:
http://user.services.openoffice.org/en/ ... 83&t=40493
It is possible to copy and paste forms into Calc or Draw and reconnect them
as described in the tutorial linked above.
quite a lot of advantages. You may also use the tabbed interface of Calc or
Draw for your input forms.
1) You get form documents that can be opend by means of simple desktop links
so you never see the database document.
2) The form documents or pages (sheets) in the same form documents can be
connected by means of hyperlinks (switch boards without coding macros).
3) You can protect the form documents from modification by means of document
protection or on file system level.
4) In the tabbed Calc interface you can elegantly mix input forms with
report sheets (enter invoice, print latest invoice, search invoice, also
without any coding). The layout and print capabilities of Calc are good
enough and it can easily do all sorts of calculation which are sometimes
more difficult to do in a database.
5) All Base features always refer to a single data source. In stand-alone
forms documents you can connect a form to a row set from database A and
build a relation through a subform connected to a row set from database B.
Now for the only draw-back I'm aware of:
The Writer documents embedded in the Base document store their own settings
for window size, menu bars and view settings. When using stand-alone
documents for input forms, the initial window sizes and view settings are
the same as with any other documents of the same document type.
Step-by-step instructions on how to save an embedded Writer form as a
stand-alone Writer form:
http://user.services.openoffice.org/en/ ... 83&t=40493
It is possible to copy and paste forms into Calc or Draw and reconnect them
as described in the tutorial linked above.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Run db stand alone?
Hi Villeroy,
This close enough to what i want. Thanks.
Erik
This close enough to what i want. Thanks.
Erik
OpenOffice 3.3.0 on Windows 7
Re: Run db stand alone?
If this has answered your question please go to your first post and use the Edit button, and add [Solved] to the start of the title. You should select the green tick icon at the same time.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust