I've used SYS(2023) for quite some time as a place to create temporary files. Suddenly on only five of our workstations, the alias values of such an open temp file in the system temp path changes the stored path in memory at runtime.

In other words, I have a procedure that creates and opens 6 temp files in the same directory with unique file names. Only on the 4th file, does the SELECT command fail and only on 5 of our 20 workstations and only since yesterday. Nothing that I know of has changed on these workstations in the last several weeks.

Below is the code. Note that before this code runs, the exact same code creates and opens 3 other temp files the same way.

What seems to be happening is the short verses long directory names. Somehow the short directory names are changing to point to another structure with-in the persons windows 2000 profile between the 3rd and 4th SYS(2023) call?

IF Used('UACQuery')
SELECT UACQuery
USE
ENDIF


SELECT 0
CREATE TABLE (AddBS(Sys(2023))+THISFORM.FILEUAC) FREE ( UAC C(03), LOB C(03), CO C(03), ACTION C(10), DESC C(80) )
IF USED(THISFORM.FILEUAC)
SELECT (THISFORM.FILEUAC)
USE
ENDIF
USE (AddBS(Sys(2023))+THISFORM.FILEUAC) IN 0 ALIAS UACQuery EXCLUSIVE
SELECT UACQuery && <==== Fails here
INDEX ON UAC TO (AddBS(Sys(2023))+THISFORM.FILEUAC)
SET INDEX TO (AddBS(Sys(2023))+THISFORM.FILEUAC)