Record Locking: 599cd.com/RecordLocking

Are there multiple users running your database at the same time, or are you the only one using it?

He doesn’t cover error 3502 specifically, but the video I mentioned above generally explains record locking.

He covers reading/writing registry keys using VBA in his VBA Editor Theme series.

Alex - thanks for replying.

To give some background, I was adding consecutive numbers to a table with 13k records, see below
--
'STEP FIVE - ADDING CONSECUTIVE NUMBERS TO tblMASTER
Private Sub MasterConsecutiveNoXs()
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset(SQL)
rs.MoveFirst
ZZ = 0
While Not rs.EOF
ZZ = ZZ + 1
rs.Edit
rs!RndNo = ZZ
rs.Update
rs.MoveNext
Wend
rs.Close
Set rs = Nothing
Status "Determining total records = " & ZZ
End Sub
--
Having posted to the forums and then taken a deep breath, I have compared the above recordset to a recordset that is working okay.

I can see how the problem has come about.  

I defined ZZ as String when I should have defined it as Long.  Hey presto, the problem has gone around. I guess defining ZZ as String takes up many more records given rs!RndNo - see above - is a number.

Sorry, I should have done the comparison earlier.  Thanks again for replying.

This is one of the reasons why I say it's important to have meaningful variable names, even if they're only short temporary variables like S for a string, L for a long. Those kinds of things. ZZ is completely meaningless; you got no idea what ZZ is, but if it was S or L, you'd have a better idea.

It's a fair cop.  I've certainly learned my lesson (until the next time).

Now onto another recordset.