The Anti Virus is turned off.

Note that the program and param.dbf are in F:\data, which is a mapped network drive by Novell. The problem does not occur when I'm using a local drive. Here is the code that is causing the problem:

CLEAR
CLOSE ALL
SET SAFETY OFF
SET CENTURY ON

* In my Config.fpw, I have the following line:
* TMPFILES=c:\junk
* The following line confirms that C:\junk is the temp folder, so no long names here
MESSAGEBOX(SYS(2023))

USE param

TRY
* if PARAM.scexp doesn't exist, then we do the CATCH
	X = PARAM.scexp 
CATCH

* THE FOLLOWING LINE BOMBS WITH A 1410 ERROR
* "UNABLE TO CREATE TEMPORARY WORK FILES"
**** WHY? ********
	ALTER TABLE PARAM ADD COLUMN scexp c(3)  
	REPLACE scexp WITH '90'
ENDTRY

Can anyone help on this?

Thanks,

Yossi


>Hi Yossi,
>
>Try turn off antivir. Many antivirs in default settings check all files (include dbf, fpt, cdx, idx, scx, sct, vcx, vct etc..)
>
>MartinaJ
>
>>Hi Martina:
>>
>>I'm no longer using the macro and still getting the error.
>>
>>I want to try and specify a temp folder with a short name. Forgive me, but I've forgotten how to do this with my EXE. Can you help me?
>>
>>Thanks,
>>
>>Yossi
>>
>>>Hi Yossi,
>>>
>>>No, makro(&) has problem with long names.
>>>
>>>MartinaJ
>>>
>>>>Hi Martina:
>>>>
>>>>Sorry for delayed response!
>>>>
>>>>1) I'm using (tcFileName)
>>>>2) sys(2023) is c:\DOCUMEN~\SSM8\LOCALS~1\TEMP
>>>>
>>>>Could it have something to do with Novell not being able to handle long file names?
>>>>
>>>>Thanks,
>>>>
>>>>Yossi
>>>>
>>>>>Hi Yossi,
>>>>>
>>>>>1) instead &tcFileName use: (tcFileName)
>>>>>2) what is value of SYS(2023) on client machine?
>>>>>
>>>>>MartinaJ
>>>>>
>>>>>>Hi All:
>>>>>>
>>>>>>I have a program that works fine on my end, but my client has a problem. He's running Windows XP with Novell.
>>>>>>
>>>>>>Here's the code:
>>>>>>
>>>>>>

>>>>>>tcFileName = 'PO'
>>>>>>WAIT WINDOW NOWAIT 'Now processing ' + UPPER(tcFileName)
>>>>>>USE (tcFileName)  EXCLUSIVE
>>>>>>
>>>>>>TRY
>>>>>>	ALTER TABLE &tcFileName ADD COLUMN chk c(1)
>>>>>>CATCH
>>>>>>ENDTRY
>>>>>>

>>>>>>
>>>>>>On my machine, the above code adds a new field 'chk' the first time the program is run and all subsequent times, it raises an error which is CATCHed, since the field already exists.
>>>>>>
>>>>>>On my client's machine, it never adds the field, since it always gets an error. The nessage states 'unable to create temporary work files'. This error happens even when I strip the file down to 5 records. i.e. it is not a size problem.
>>>>>>
>>>>>>Can you help?
>>>>>>
>>>>>>Thanks,
>>>>>>
>>>>>>Yossi