Hi,

> Do you know a way for entirely locking the file while it is used with the embedded server, but without causing conflicts with it?

Not the same way as it was with <2.5 when SuperServer was used.

You could try to bring the database into single-user mode by using the
new shutdown modes, but then, a privileged user is able to bring the
database back into multi-user and normal mode again.

You could also try to create an ON CONNECT trigger which throws an
exception in case of too many connections.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/