By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,464 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Help with updating

P: 4
Hi All

I need help with the following. I have a database in Access that has more than 150000 records. There is NO Primary key and over the past year or so people have been working with it and making some changes to the records. However our Head office has sent us a NEW version of the database. I need to be able to take the new verson and add it to the my existing database so that it can update it with records that have been removed and also update existing records with more current information. Note BOTH databases are the same in terms of having the SAME fields, structure etc except the NEW verson has changes and updates with needs to pulled into and my existing database. PLEASE tell me how I go about doing this, we are currently using Access 2000.
Sep 11 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi All

I need help with the following. I have a database in Access that has more than 150000 records. There is NO Primary key and over the past year or so people have been working with it and making some changes to the records. However our Head office has sent us a NEW version of the database. I need to be able to take the new verson and add it to the my existing database so that it can update it with records that have been removed and also update existing records with more current information. Note BOTH databases are the same in terms of having the SAME fields, structure etc except the NEW verson has changes and updates with needs to pulled into and my existing database. PLEASE tell me how I go about doing this, we are currently using Access 2000.
You say there is no primary key. Is there any field that uniquely identifies a record? If not you have a bit of a problem.

Are all the existing records present in the update. What I mean is could you just replace the current records?
Sep 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.