replication for 1 DB, 3 offsites users

[xili]

Hi,

I created a survey DB for 3 interviewers, they'll use laptops to do the same questionnaires. Then I want to combine all data into one DB. Should I use replicaiton to create 3 replicas for them? how could I combine them together without worry about the unique Autonumber(questionID, responseID, etc) will be same? (note: I have no experience with using ACCESS replication)

Any suggestion would be highly appreciated.

 

[xili]

Could anyone provide a suggestion for me, thank you in advance.
Is the replication only used for network sharing one DB?

 

[Shane23]

When you create a replica database, your autonumber fields will be changed to random rather than sequential numbers. This is to minimize the chances to two users generating identical primary key information. You may need to check your database design to make sure that this does not cause any complications.

Shane