hi , i am trying to implement record locking using transactions on an access database thru asp. i am closing all my recordsets and connections etc so that is not a problem i think. I have personal web server running on nt workstation 4 with sp3 installed.

Failed to enlist on calling object's transaction

And when i use the BeginTrans and CommitTrans commands it says:

[Microsoft][ODBC Microsoft Access 97 Driver]Operation invalid at this time

Any ideas ? suggestions ? all will be appreciated as i am desperate.

clive