I am trying to loop through a recordset and update a single field by taking out the dashes in the phone number in that field. This is the code I'm using. I am getting the error "Cannot Update. Database or Object is Read Only". I thought the OpenKeyset cursortype and adLockOptimistic lock...
I can't figure out why I'm getting EOF or BOF error when looping through only a couple of times...
Do While rst.EOF = False
testNo_Rows = rst.RecordCount
iPhoneNumber = CStr(Replace(rst("SUBSCRIBER #"), "-", ""))
iAmountLoaded = rst("SUBSCRIBER TOTAL")
iAmountBilled =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.