Our workflow requires two users to work on the same Access database. The problem is that users are geographically separated and can't work on same
.accdb file simultaneously.
So, the only way i see to solve this problem is to periodically merge each user's DB's into one. If there is another way, please share you thoughts.
I've googled for how to do this in Access, but haven't found easy solution. I mean, this operation seems to me quite natural and i've been expecting that Access can do merging "out of the box". But what i found are advices to write special queries for each table being merged.
I'm fine with this, since my tables are simple, but i wanted to know if there's better way and how such problem should be properly solved.