>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

The TableUpdate() will take care of this as well.