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