2 users - no connectivity

[zinx]

I have created an access application that up until just recently I thought was going only be used by one person at a time on one machine.

Now I have just found out that two people are going to use the database at the same time only they won't be connected. Essentially two separate copies of the database.

The good part is that they won't be accessing the same records, but I don't know which records will be accessed so I can't break it down into two databases.

Is there an easy way to compile the changes to these two databases together once I get them back?

 

[The_Doc_Man]

Look up Help Files topic "Replica"

You can make two database a replica and then run a replica reconciliation.

Read up on it. I've not used the feature much myself 'cause I have a network to connect my users together. So all I can really tell you is that it exists as a way to handle lap-top db files.

 

[zinx]

Thanks Doc Man, I created a copy of my database and went through the whole replica/replication process on it and it was very easy. This works perfectly for users that don't have a connection, like laptops.