Split Database, Can't Append to Table

[Guest]

I have a table to which I daily upload financial reports into one table, and
run an append query to add those records not already listed in the master
table. I recently split the database because of some other random conflicts
we began to have once two users began to access the database. I read that
splitting might help. Now I am unable to append to the master table using
the append query. I get a message that there is a violoation regarding an
index, primary key, or relationship. I've also tried to manually cut & paste
the records from the results of the append query with no success. Both the
updated table and the master table have a autonumber primary key. I've
verified that nothing has changed. The two tables are still formatted
exactly the same as before they were split--and that process has worked
effectively for me for about 3 years now. Any ideas?

 

[Pete D.]

Make a find duplicates query by clicking on the new button in the query
window. Use you two tables and select the key fields for the query. Run it
and you should find your problem. Think you'll find a problem between you
auto number fields.

 

[Guest]

Thanks Pete, but I may need a little more clarification. When I created the
find duplicates query, it only allows you to search for duplicates within one
table. I ran it on the master table, and it didn't find any results. Of
course, I wouldn't expect it to since I can't get the other table to append
because of the key violation. I am by no means an access guru, so I may be
missing something.

 

[Pete D.]

Within one table or query. Make a query of the matching key fields and then
make a find duplicates query.