Record is locked by another process, but I dont know understand

[Pack10]

I have a procedure that reads in emails from an outlook inbox and writes them to a table. There is an inner loop that reads for attachments and writes the filename to a table linking it to the original record (outer loop). It works fine. It is in development and I have it checking the inbox every 10 minutes. I have the code in a With End With with recordset.close and Set Recordset = Nothing.
I'm seeing some behavior I don't understand, if i exit all the routines forms queries etc...and open the table to check, I get a message that the record is locked by another process. If I close the database then go back in its fine....but I am not sure what process is running. Also after the first time the procedure runs, I notice a record lock icon on the split form.

 

[SkipVought]

hi,

If this is MS Access VBA, then please post in forum705.

Otherwise please state the Application that you are coding in.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}