[Tutorial] OOo Base in networked environment.

Forum rules
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
Post Reply
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

[Tutorial] OOo Base in networked environment.

Post by r4zoli »

You can use OOo Base in networks, but don't forget that OOo Base is designed as a single-file, single-user database application for desktops.

If you intent to use Base in networked environment, your needs will drive you into two directions.
  • First use is not really suggested in networks, but you can use it if you don't want to go the second direction. If you use odb files rarely and if only one user at a time uses it, you can copy the odb file on a network drive. If a file has been opened by a user, when other users try to open the odb file, they won't get any error message, the Base odb file will be read only and functions grayed out. They will still be able to search in tables, run queries, forms, reports, but no data change will be allowed. Some drawbacks if you chose this solution: no user authentication; any user in a network who has a read/write access can use the odb file; you cannot follow who made the changes in the database; you cannot withdraw changes.
  • The best use of OOo Base in networks is to apply a “real” database server (MySQL, Postgresql, Firebird, etc.) with ODBC or JDBC connection to OOo Base. In this case, database tables are stored on the server and OOo Base works as a front-end; you can use database servers authentication, and use forms for data input, querying, and the reporting features of Base.
Links to different sources to OOo Base, databases and database drivers:
Connect MySQL and Base.
native MysQL driver
postgresql-sdbc-driver
sqlite-sdbc-driver-0.1.0
Firebird driver update for OO.org
OpenOffice Suite powered by Firebird Database
User avatar
MSPhobe
Posts: 93
Joined: Tue Jan 15, 2013 6:05 pm
Location: Usually UK, sometimes USA(CT)

Re: [Tutorial] OOo Base in networked environment.

Post by MSPhobe »

Since the post above was written, Open Office's database has been provided with a "native" connector for MySQL.

It is now (March 2013) possible to use Open Office as your front end, or "client", with a MySQL server. This opens up possibilities (multi-user, remote access to a database)... but is, of course, more complex.

For a guide to using the Open Office Base native MySQL connector, and associated material on setting up, running a MySQL server, see....

http://sheepdogguides.com/srv/s0MySqlDoInst.htm
Last edited by RoryOF on Fri Mar 15, 2013 12:17 pm, edited 1 time in total.
Reason: Expanded a date reference to avoid ambiguity.
OpenOffice 4.1.1 on Windows 7, plus others on XP. "Native", and as FE to MySQL
Post Reply