DURING COPY from TABLE to TABLE ERROR 3022

[rickyfong]

I am using simple copy statements as follows to copy the content from one table to the other, but the ACCESS 2003 keep on telling me there got an error "3022" problem, it is about index or primary key duplication or empty problem etc.


do while not trans2.EOF
trans1.addnew
trans1.[name] = trans2.[name]
trans1.[age] = trans2.[age]
trans1.update
trans2.movenext
loop

In fact, I have tried to erase all the contents in both tables and also doing the compress database activity!! The result is still the same!! FYI, I using a field as primary key but not numbering generated by ACCESS 2003.

Please help to by pass this problem as it is quite new to me then!! Thanks a lot!!

 

[gemma-the-husky]

your table is set up with a particular field or set of fields, set to unique YES.

your statement is trying to add a value that already exists, so you get the error message. If you do want duplicates, then change the index.