Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
addnew
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
addnew | Excel Programming | |||
Addnew | Excel Programming | |||
Simultaneous rst.AddNew and rst.Delete from 2 Workbooks | Excel Programming |