I am working on an app that requires the EXE, Database and tables reside locally so the users can work on the system when not connected to the network. A copy of the Database and tables will reside on the network as well as a master data warehouse for users to upload/download to/from.

I am looking for suggestions on the best way to do this. Can more than one DBC be open at the same time?