Table won't Update

[Jim Jawn]

I've got a function that records error messages as they occur and then saves
these messages into a table so I can track application errors. Everything
has been working so far so good until today. Everything in the procedure is
proceeding correctly, the ado objects connect and successfully update and
everything in the procedure occurs very smoothly. There are no problems in
the function from what I can tell (as nothing has really changed). However,
when I open up the errors table, the last error to get processed by the
function doesn't show up in the table.

Its like the table didn't record it at all. I tried deleting the original
table and rebuilding a new table. I've checked the other tables in the
database and they seem to be working correctly. Anyone have any ideas on how
I can track this down or has anyone had experience with something like this
previously?

Thanks,

Jim Jawn

 

[Jim Jawn]

Oh yeah...

Here's the weird thing... When I manually enter a value into the table, the
Autonumber increments to the correct number. IE - I force an error 3 times
at ID 6 and then I manually enter a dummy error, I get the ID of 10.

 

[Jim Jawn]

Nevermind.

I realized that the procedure that was calling the error handling had a
connection object that was in the middle of a transanction. That's why the
data was being written, but not stored.