> Thanks to Helen and others for answering my ODS question...
>
> The next concern I have about FB as a solid solution for our project
> is this:
>
> "Our database will reside on a USB-attached disk with the server
> running on the host system. Of course, end users will simply unplug
> the drive without shutting us down first. What is likely to happen
> (under Windows) to a FB database that is unplugged at unpredictable
> (and probably the worst possible) times? Will the whole db be lost?
> What are the recovery options? Anything I haven't considered?"

Well, from personal experience, I can tell you that ANY
file write operation can be lost, eg: a simple "copy file"
in Windows explorer can be lost if you do not "detach" it
properly.

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