E
emch62
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?
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?