I develop an application that saves records in MS Access DB.
Each user has it own DB copy on his local machine, and there is a central DB that reflects all the copies from everyone. The central DB is located in a URL that everybody can access.
I therefore distribute the central DB by creating local
copies that are links to the central tables.
This means that the local DBs are
synchronized with the central since they are links to it.
However, this solution
disable the option to work offline- if a user is not connected to the URL, he cannot save anything on the local DB which is a link to the central .
I therefore have another option: to distribute the central DB by
copying deep copy, and locate a copy (not link) on each machine. This
enables to work offline since each user has a full copy of DB on hos machine.
no synchronization among the copies and the central DB.
Is there any solution that enables both offline work and full synchronization? Any Ideas?