Update: Forgot to mention that the tables all reside on a server and all are Windows XP Professional. None of the other workstations exhibit this error, in fact, when you receive the error if you move to another workstation the same code will run fine. It is in a prg that runs directly from the main menu in the default data session. No forms are even open at this point. The funny thing is that only restarting the SERVER (not the workstation) will free up the file for that workstation once the error occurs. It only happens on ONE workstation and ONLY on that line (after the file is opened and when the index order is set).

On one machine only in Windows XP Professional we get a file in use error when an index order tag is set. I can verify that the table is open (only once) on the same machine and this error only happens on a single machine (so far). Everything appears identical to other machines when this error occurs (program trace, data environment, etc.)

	WAIT WINDOW "Searching Receipts..." NOWAIT
	SELECT 0
*--ERROR DOES NOT OCCUR HERE - the file opens fine
	USE (ddir+"archeadr") ALIAS arcorg
	IF bad_error
		=okay("Receipt file is in use.  Please check other workstations.")
		IF !EMPTY(dbfarea)
			SELECT(dbfarea)
		ENDIF
		RETURN
	ENDIF
*--ERROR OCCURS ON NEXT LINE and error is FILE IS IN USE
	SET ORDER TO TAG profile
	*---Open Transaction File
	USE (ddir+"arctrans") ORDER TAG re_link IN SELECT(1) ALIAS arctrorg
	SET RELATION TO re_link INTO arctrorg