473,324 Members | 2,248 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Help with updating

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
1 1079
MMcCarthy
14,534 Expert Mod 8TB
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

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

Similar topics

0
by: htmlgeek | last post by:
I'm adding and updating records in an Access .mdb via WWW .asp page. Authored in Dreamweaver 2004 MX. Help is welcome on this one. I have a great set of pages that work fine, but it seems that...
0
by: htmlgeek | last post by:
I've beaten my head againts this for two weeks and would appreciate any help. Am running Dreamweaver 2004 MX asp pages with MS Access 2000 and then 2003 and received same problems! I've rebuilt...
1
by: | last post by:
Hi all I am posting this to check if anyone could help me. The problem still persists. I am beginner in C#. Thanks. Subject: SQLDMO.Backup and ProgressBar - help please From: ...
1
by: Alpha | last post by:
I have a Window based application that shows up still running in the task manager when I close it. It reaches the "this.close" statement and then it stops at the "}" at the section of the...
2
by: Eric Sykes | last post by:
After installing VSNet for several reasons I had to restore the system to before the VSNet installation. I reinstalled VSNet no problem but now when I open up VSNet a message pops up saying "Help...
55
by: Sam | last post by:
Hi, I have a serious issue using multithreading. A sample application showing my issue can be downloaded here: http://graphicsxp.free.fr/WindowsApplication11.zip The problem is that I need to...
14
by: el_sid | last post by:
Our developers have experienced a problem with updating Web References in Visual Studio.NET 2003. Normally, when a web service class (.asmx) is created, updating the Web Reference will...
5
by: Hexman | last post by:
I've come up with an error which the solution eludes me. I get the error: >An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in HRTest.exe > >Additional...
1
by: blazerguns | last post by:
Hi all, Can someone give me pointers and may be some code samples to start off with windows update management. Iam planning of writing it on c#. Any sample code will of great help. I browsed the...
5
by: tabani | last post by:
I wrote the program and its not giving me correct answer can any one help me with that please and specify my mistake please it will be highly appreciable... The error arrives from option 'a' it asks...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.