Using code rs.AddNew for a recordset, and I have placed the call at the
beginning of my code. I then check to see if the Primary Key is violated, if
not the program proceeds, but if the PK is violated the program goes to the
next record. Since you cannot close rs.AddNew (at least from what I
understand) I must have it outside the loop. If no records with new PKs are
found the program ends. The problem then is that I cannot perform rs.Close
and I get an error message "memory could not be written." Is there a way
around this? Thank you.

Brent