Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2000 replication

Status
Not open for further replies.

Eradic8or

Programmer
Oct 29, 2000
159
GB
Can someone tell me if I can accomplish the following?

I have a Access 2000 database which has very tight network permissions on it. I want to create a replica of it where everyone has full read/write access. The problem is I don't know much about replication. I want to be able to do synchronisation on the fly but also only to be one way. I DO NOT want any changes made to the replica passed back to the master but I do want the master to over write any changes made to the replica everytime it synchronises.

Is repliaction the best way to go or should I just write a piece of code that tells the database to copy itself once a day?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top