Thanks Tracy

I passed that on to my colleague but, as you'd expect, he'd already done all that.

Terry

>I would do the basic troubleshooting:
>
>1. There is no if found() .or. !eof() etc after the seek to verify you are not at the end of file.
>2. Set step on after the seek and what are the values and TYPE of:
>
>thisnewid
>thisform.txtnewId.value
>idnumber
>thisnewid
>entry
>oParam.thisinits
>
>Verify whethe each value is character as well as the field type, etc.
>
>
>>Dear Foxperts
>>
>>A colleague has asked me to look into this problem. please observe the code below:
>>

>>sele m_cust
>>set order to idkey
>>thiskey=oChist.idkey
>>seek thiskey
>>thisrec=recno()
>>thisnewid=thisform.txtnewId.value
>>repla idnumber with thisnewid,;
>>	entry  With oParam.thisinits+':'+Dtoc(today)
>>

>>
>>An error occurs at the last line: to wit:
>>
>>

File is in use by another

>>
>>Now there are no other users on. This code is used for several sets of data (each customer has his own set) and only occurs with the data for a particular customer. It is a private dataset and the tables are opened shared.
>>
>>This occurs on one form with 31 tables opened in the data environment. This form also calls another which
>>has a private data session - which also uses M_CUST.
>>
>>He looked at the status of his VFP environment (DISP STAT) and discovered, at the "Lock(s)" header for the table, M_CUST, instead of "none" or "Exclusive use", a value of "6161"
>>
>>There is no guide for parts of the disp stat output in Help and I'm stumped too.
>>
>>Any ideas?
>>
>>Thanks
>>
>>Terry