Sharing Base Files on a server

SOAD · General User Joined: 29 Jun 2009 Posts: 7

I have created a database using Base with version 3.0 and it works fine on my PC but when I copy the database file to our server so a colleague can open and edit the file the following error comes up

The connection to the data source “Mailing List” could not be established

General error: org.hsqldb.lib.FileSystenRuntimeExeption:
Java.io.IOException:

r4zoli · Posted: Mon Jun 29, 2009 10:54 pm Post subject:

OOo Base files created as single file single user, if you use in a server only one user can use it in one time. If you want to use base as multiuser database, it can not possible, in that case use OOo base as front end to other real database as myasql or postgresql.
You have write right on this server folder?
OOo needs to create a lock file next to the odb file.

MSPhobe · Posted: Tue Jun 30, 2009 11:41 pm Post subject:

Very much a work in progress, and a HUGE essay... but at....

http://sheepdogguides.com/fdb/fdb9mysql1.htm

... you will find discussion of setting up MySQL for home user/ small business so that you can have a shared database on a central server, for multi-user access, using ooBase as the client. I.e users will only need ooBase skills once the central database has been extablished, links to it set up on the machines accessing it.