View Single Post
  #1 (permalink)  
Old April 3rd, 2006, 10:33 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default Append Query Error Message Misleading

I have a backend table that is appended to an empty front end local copy of table (same structure) in the database. The reason is to allow the user to use data from the back end located on the network at a local level to speed them up (it's painfully slow otherwise because users are scattered across the state).

In Access XP (2002), I'm getting a key violation error message when the query that imports the data to the local table runs. The local table is completely empty, so I don't know why there would be a problem. The only indexed field that is set to Indexed (No Duplicates, autonumber) is lngRecNo. However, my query does not try to put data into that field; it only tries to populate the other fields in that table. The table does have a foreign key set to Indexed (Duplicates OK).

Can anyone think of why the key violation would happen? Thanks in advance for your help.
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division
Reply With Quote