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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Replication

Status
Not open for further replies.

BeallDon

Technical User
Aug 20, 2007
46
CA
I am considering replicating my database for a multi-user environment. I have tested it a few times and the only issue that I have with replication is that in each of my tables, I have a primary key field that is an incrementing autonumber and after I create the replica, every single one of these fields (in every table) is changed to a RANDOM autonumber. This change affects some of my formulas.

Does anyone have any comments or suggestions on what I can do to possibly prevent or deal with this?
 
Do you need replication for disconnected operations, or could you just have multiple front ends acessing a shared back end? I can not imagine a reason for using an autonumber in a formula. Can you explain?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top