ADO updatebatch

[2969]

hi

i am having a weird issue. I have a code that runs well but then it fails on updatebatch command for no reason. It does not gives error also but stays therelike the machine hangs up.

Can anybody give me some ideas as to what to do and how to solve this issue.

thx

 

[MarkSweetland]

Make sure your recordset LockType is opened with LockType = adLockBatchOptimistic


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[2969]

That's what I have. Here is the code to open recordset.

rs.Open SQL, mcnn, adOpenKeyset, adLockBatchOptimistic

I use this for saving

rs.updatebatch

This code is present in a active X DLL and would run fine for like 4-5 time doing what it should do. Then 6th time it would just hang up and do nothing.

thx