Peter,

> Right, but this is something that can happen in different situations, and
> the recommendation is to use transactions if you cannot guarantee the
> operation to complete successfully.

Sure, transaction - logically - work. But if a process is writing the
file (on a network) and THEN something happens, you'll have a
corrupt database, transactions or not.

>Would you say this is why firebird
> embedded does not allow access to a DB file across a local network?

Yes.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com