Artur Anjos wrote:

> We have some customers that use the database on a USB disk. We do
> software for kindergartens, and some time the owner want to take all the
> data with him to work at night at home - it's just small databases,
> normally 30-40Mb (without children pictures). Works like a charm, but
> they have strong warnings about it, so they stop the application (Fb
> Embedded, so the file is not open by any service), copy the database to
> the hard disk first, and disconnect the usb disk.

All this is fine, but I *never* let user do it. I always store database
on hard disk. When user wants to take data with him, he clicks "take the
data" button, and my app. runs backup from HDD database to USB disk. Of
course, I also have a button to restore in on other computer.

If you don't like the backup/restore idea, you can always copy the
database file onto USB disk. It is still safer than having a live
database there.

The idea of having both app. and database on flash is great, but users
usually do have access to HDD on the computers they use, so why risk.
IIRC, people who use Firebird like to sleep tight at night. ;)

--
Milan Babuskov
http://www.flamerobin.org