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.
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.