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