Hi all, I currently have 2 databases: a main current database (Main.mdb), and a secondary database (Working.mdb).
They are identical, except the working database has no data, just the existing tables, forms, etc. from the main database.
When I (or a programmer) makes changes to the forms and some underlying calculations, they are first made in the Working database.
After the changes are made, i delete all the data from the tables in the working database (data from testing, etc.). I will then copy all of the data from the tables in the Main Database over to the Working database, then rename the Working Database to the Main Database.
The only problem I'm having right now is that the primary key in one of the tables (ClientID) is an autonumber. When I paste the data into the Working Database, all the ClientID numbers change. Is there any way to keep the numbers the same as the Main database?
Thanks in advance!
They are identical, except the working database has no data, just the existing tables, forms, etc. from the main database.
When I (or a programmer) makes changes to the forms and some underlying calculations, they are first made in the Working database.
After the changes are made, i delete all the data from the tables in the working database (data from testing, etc.). I will then copy all of the data from the tables in the Main Database over to the Working database, then rename the Working Database to the Main Database.
The only problem I'm having right now is that the primary key in one of the tables (ClientID) is an autonumber. When I paste the data into the Working Database, all the ClientID numbers change. Is there any way to keep the numbers the same as the Main database?
Thanks in advance!
