Hi Ria,

In addition to sergey, you can either use the table exclusively or use a filelocking strategy.
Useing Exclusive access has the downside that other users cannot use this table.

For filelocking other users cannot write to the table during the transaction

SELECT mytable
IF FLOCK()
	SCAN
		standardize(mytable.address)
		REPLACE streetname WITH stname, ;
                        streetno WITH stno, ;
                        predirectional WITH predir, ;
                        secondaryaddr WITH secadr
	ENDSCAN
ENDIF
UNLOCK IN Mytable

In both circumstances VFP does not have to check for concurrent record locks. With exclusive access a workstation could use writebuffering.

Walter,