Access DB Merge or other procedures

[supportt]

Could anyone give me some advise on the following: I have an access DB setup on a workstation, where several other PC's access the access application; basically network sharing. And aslo, we are doing this over DSL/VPN. The big question is, when DSL goes down, is there any way users would be able to continue working? I know they could have a local copy of the Access DB, but that might get messy. Having 3 or 4 users working on local db until the DSL connection comes back up and then would they have to merge all the local db's with the main database?

Looking for some good ideas on the best setup for this.

Thanks

David

 

[Travis]

Look into "Replication". Each user can use a local replica of the database and syncronize it with a Master DB.

 

[supportt]

synchronize

I found a pretty simple way yo do this, just want to run it by you. Basically I copied the original DB to My Briefcase and it created a Replica of the orignal, once users have the replica, they would be working against that copy and when they are done for the day. They can open My Briefcase and select Briefcase, then Update All and it updates the master DB. I tested it with one record and it seems to work. Question, does each user need to create there own Replica ? or can I just make one and then copy it to the other pc's? Also, is there going to be any issues with running the update all with multiple users?

ust trying to figure out if this is a good approach

Thanks for the help

David