Access 2003 Append query Key violation error

N

Nemo

I have done append queries before, though not recently, so I may be
doing some very simple error to which I am oblivious. I am using the
query window.

When the query I wanted to do ran into Key Violation errors, I
simplified it to this:

INSERT INTO tblProjects ( ProjectName )
SELECT [0506import].ProjectName
FROM 0506import;

I still got Key Violation errors. I did have tblProjects open but now
it is closed. TblProjects.ProjectName is text, 20 char, Not required,
Allow Zero length strings, No index. The Import table Project Name
field has exactly the same properties.

What else can I check?

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Manage append query key violations? 4
Append Query Key Violation 5
Append Query - Key violation 1
key violation on append query 3
How do I prevent the violation error from an append query,from sho 1
key violations 4
Action Query (Append) didn't add records due to key violations. 5
Append query key violation 8

Top