On Fri, Dec 16, 2011 at 12:57 PM, Jean <jeando20032003@...> wrote:

>
> My application acts as a work group, where it can be installed in 10 desktops.  In one of the desktop, a shared directory is created to keep the database file.  Each user can access that directory by mapping it as a network drive.  The program is running locally in each machine, where all of them can modify the database at the same time.  I mean read and write to it.  I was using sqlce to do that, however sqlce only allows the file to open at once, not multiple times; so only one user can read and write to the database file at a time.
>
> I want to switch to embedded firebird to do that, I want to know if it is possible for me to do that.  Does embedded firebird enable users to open and write to the database file at the same time.
>

Firebird does allows concurrent read/write access to the database.
Given your configuration, I'd use the SuperServer version. Install it
on the workstation with the database, put client libraries on the
others, and everyone will be able to connect to the database. The
embedded
version is not well suited to sharing a database among a number of
users unless your application handles multiple simultaneous clients.

Good luck,

Ann