I want to thank you all for your help in this. The resolution to my problems was that the Access table did not have a key field. Once this was added, all the issues disappeared.

But I have one more question.

How do you delete a record? The DELETE command will only mark the record for deletion. How do you transfer this to the Access table??

Thanks