I have a replicated db where I use ADODB on certain forms to open tables not associated with that form and do processing on them--inventory stuff where if you pick something for a job and then it goes to the inventory table and takes that much out of the inventory counts. Most of the time, I'd say 85 to 90 percent of the time, this works, but there is that 10 - 15 percent where it just doesn't do anything and doesn't give any error messages(like record is deleted or something to tell me that the db is corrupted). Does anyone else out there experience problems like this and does anyone out there know of some code that would check to see if a blcok of code was actually executed successfully and produce a message to tell if it had or not? Thank you for your time.