Upload from standaolne Access to Main Access DB

Question

Hello. I have developed an Access DB to store a number of items. The main input form consists of a subform with a shared primary key. I would like to allow my users to upload data they collect in their standalone copy of the main DB (to ensure all records are available to al users) to a centrally located main DB. I considered a straight copyobject type command but I worry that there may be unique records numbers already taken when multiple users use an older version of the main DB. I will require multiple records from multiple tables (with shared record numbers) to be uploaded and hopefully have the system determine if a record number has been taken and then assign a new number to ALL associated records. Is there a way to provide my users with a button that will upload all the data they collected to the main DB in a constant location. I hope I have explained my request well enough. Thank you

Answer 1

In a like yours, I would probably recommend not using an Autonumber field. Or, if you do, at least provide another ID field to identify each unique record from each user. You can then use this information to map all the related records together.

For instance, let's say your main db has a record with ID=1. User 1 could be using something like User1ID=34 and User 2 could be using User2ID=65 to refer to MainDBID=1.

Hope that helps...