Access 2000 Database Replication

[Robert]

There is an Access 2000 database that we would like to share with each
other.

There will be total 4 people using it. If 3 of them are only updating the
records (Add new one), can I create three different replicas for the same
Master ?

If 3 of them have to update existing records, for instance, A updates the
record to 3, B updates the value to 4 and C updates the record to 5 and they
replicate with the Master, it will depends on the sequence of replication &
the resulted record may be 3 / 4 or 5 ? What is the best solution to this
kind of data inconsistency ?

Your advice is sought.

Thanks

 

[SusanV]

Unless there's something else involved, such as low bandwidth between
locations or some such, there is no reason to replicate this for only a few
users - Access allows multiple connections simultaneously. The only
limitation is if 2 users were trying to update the SAME record at the SAME
time - then there would be a write conflict and someone's changes would be
lost. Simply share the db in a central location, and make sure all users
have full control on the folder it resides in as well as the db itself, and
give them each a shortcut.

 

[Robert]

Dear Susan,

Thank you for your advice.

However, I find that the existing database has already been converted to
Master (Someone must have run the Create Replica before). Is there any way
for me to change it back to a "normal" database ?

Thanks

 

[SusanV]

Hi Robert,

I'm not certain you can convert it back - but perhaps this FAQ will help:
http://support.microsoft.com/kb/q282977/

 

[Robert]

Dear Susan,

I find that the following link is helpful
http://www.trigeminal.com/utility.asp?ItemID=7#7

Robert

 

[SusanV]

Excellent Robert - and thanks MUCH for sharing!

Dear Susan,

I find that the following link is helpful
http://www.trigeminal.com/utility.asp?ItemID=7#7

Robert