I have developed an app which the DB and MyApp.exe will be installed on a server, and all clients will run MyApp.exe from the server. This is intended to simplify network deployment & maintenance etc.

For simplicity I would like to use exactly the same setup for standalone single computer installations so that all installations are exactly the same.

Also the installation should play well with XP, Vista & Win 7 etc.

What is the best location on the server to store my application's FDB file? Candidates would appear to be:

C:\Program Files\MyApp\Data
(where \Data is not visible to the clients and an alias is used for security reasons)

or

C:\Documents and Settings\All Users\Application Data\MyApp\

I'd be very grateful for any guidance or good/bad experiences.

Thanks,

Mitch