Simple question probably asked and answered previously

[pablotx]

Trying to fix a simple problem with some tables.

In my department, we recently switched servers and from Windows 98 to Windows 2000. We had a database that got converted somehow during the transition. One person didn't get their computer switched until about a month later.

In essence we had 2 databases of the same information going for a while. Now everyone has the same database. Problem is the following:

Simply put:

We have 10,000 records autonumbered in one of the databases. The other database has 9,500 with the last 100 or so being information that the 1st database does not contain. How can I update my main table to have all 10,100 records? I have tried an append query and it doesn't seem to be working right. I have also tried to 'find unmatched' but can't seem to make that work either. There has to be an easy solution to make it work in one step.

Any help would be great. Thanks in advance.

 

[llkhoutx]

The autonumber field is the problem; dulicates are probably not allowed.

If the records to be appended have no children, merely append all fields except to autonumber field.

If there's children, the solution is more complex. Of course you have to append them too and they might have indicies conflicts. You can do that record by record, that is appending a record with DAO or ADO code, getting its index, then appending the children with the appropriate index.