I open a table shared...
USE lcGdir + 'safusers' IN 0 shared

and then I create a few public arrays...
PUBLIC ARRAY ainits[1]
PUBLIC ARRAY ainitf[1]
PUBLIC ARRAY ainito[1]
PUBLIC ARRAY ainite[1]
PUBLIC ARRAY ainitr[1]
PUBLIC ARRAY ainiti[1]
PUBLIC ARRAY ainitv[1]
PUBLIC ARRAY ainitm[1]

and then I try to populate the arrays from the table through a series of select statements...
SELECT DISTINCT INITIALS FROM safusers INTO ARRAY ainits
SELECT DISTINCT INITIALS FROM safusers WHERE 'f' $ discp
ORDER BY INITIALS INTO ARRAY ainitf
SELECT DISTINCT INITIALS FROM safusers WHERE 'o' $ discp
ORDER BY INITIALS INTO ARRAY ainito
SELECT DISTINCT INITIALS FROM safusers WHERE 'e' $ discp
ORDER BY INITIALS INTO ARRAY ainite
SELECT DISTINCT INITIALS FROM safusers WHERE 'r' $ discp
ORDER BY INITIALS INTO ARRAY ainitr
SELECT DISTINCT INITIALS FROM safusers WHERE 'i' $ discp
ORDER BY INITIALS INTO ARRAY ainiti
SELECT DISTINCT INITIALS FROM safusers WHERE 'v' $ discp
ORDER BY INITIALS INTO ARRAY ainitv
SELECT DISTINCT INITIALS FROM safusers WHERE 'm' $ discp
ORDER BY INITIALS INTO ARRAY ainitm

...but it errors out on the first Select statement :"File Access is Denied."

I remarked out the first and then next statements to the end to no avail.

Does the select statements create a temp file somewhere? Im on a 95 machine, the data resides on a NT server where I have full Admin priv's.

Does anyone know what could cause this?


Thanx,



Michael Mead