Hi,

I have a number of websites built using ASP - COM (VFP9 DLL) and I noticed a problem.

From time to time I get an error from the COm object on a line like this:
CREATE CURSOR _tempAllReg (reg_text C(20), country C(30), region C(30), sub_reg C(30), estate C(30))
INDEX ON country + region + sub_reg +estate TAG sort UNIQUE

The erros shows on the index line it states that "File access is denied c:\windows\temp\00005vkp0004.cdx."

I also see this problem when building the cursor (first line).

It looks like the VFP DLL is serving a request from a certain user and it creates an unique file name for file (index or dbf), but if another request comes trough VFP is using the same "unique" file name?

What can I do to avoid this problem? I suspect it is related to muliple requests arriving at the same time and VFP is requesting a file name - gets it, but at the same time another request(using the same COM object) receives the same file name ...

Thanks