I wan to know if it is possible to do the following. I am new to firebird and I am playing with it now with visual studio.

I was using sqlce to do the following:

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.

Appreciate your answers