Stephen Wolfe wrote:
I was wondering if there is a way to store the database file on my hosting
space so I can allow access to it from any computer? Of course, it would
need to accept some kind of login password or some other way for me to
control access from others who use the database. I'm also guessing this
would also get more people to use OpenOffice. That would be perfect :)
-Stephen Wolfe (software designer)
wolfe1.com
Hi Stephen,
Base is a mere database front-end. It's main purpose is to "serve" row
sets to office documents.
It can connect to databases of various types, including some file based
pseudo-datbases (csv, spreadsheets).
It provides some basic tools to let you filter, sort, rearrange and
aggregate database data by means of SELECT queries.
The resulting row sets can be viewed in tables, queries and the
data-source window (also called "beamer"). They can be used in office
documents as address list, bibliography, structured source for your
calculation models and such.
Base uses the layout capabilities of Calc and Writer to present
formatted output of database data.
Input forms provide the bare minimum to let you edit relations (which is
why quite a lot new users give up with them). The resulting input forms
are _well enough_ for me. To meet higher expectations (a database GUI
that is worth some money) you need to be a fairly good programmer with a
lot of time.
The Sun Report Builder add-on links Base and Writer through a
professional, 3rd party reporting engine.
http://extensions.services.openoffice.org/project/reportdesign
As an additional "gimmick" (or prove of concept), Base lets you create
new relational databases from scratch wrapping HSQLDB tables into the
configuration file (the "database document"), so you can distribute
copies of self-contained database documents to desktop users. Refer to
http://hsqldb.org for all the details and documentation of this
database. OOo provides no sufficient documentation.
The required security measures granted, you may use OOo Base to connect
a set of forms, reports, spreadsheets and other office documents to some
remote database. Normally, you would build up a web-front-end for this.
Hope that helps,
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
