Hi,
Do you have multilocks on, also are you wrapping the updates in a transaction.
The quickest way is to copy the files to the local drive, do the update then copy the files back to the server.
BTW the default max lock settings for novell are never sufficient for a database.
>I have very little influence on the Novell settings.
>
>Is there a way to fix the problem by changing the VFP code.
>
>If I need to I can force the file to be accessed exclusively.
>Is there a way to not have novell use so many locks in VFP code.
>
>
>>Hi,
>>If you have run out of locks, an error msg would have been report at the console.
>>Also I think this is the setting
http://support.novell.com/cgi-bin/search/searchtid.cgi?/10025341.htm>>
>>BTW two weeks ago I deleted all our articles regarding Novell from our server i.e. we no longer support it, to many problems.
>>
>>
>>>>>VFP 7, Novell network
>>>>>
>>>>>I am trying to figure out why an update program in an application works if I execute i
>t on a local drive (update tables and application) it works, but when I try to execute the same program on the same tables on the network drive it eventually hangs (progrress bar stops and does not change after about 5 to 10 minuites). I table replaces existing values, other tables are log files and data is inserted at the end of the tables. If I look in task list it says application is not responding.
>>>>>
>>>>>I am not sure what to look for. This is a test system and I know I am the only one using it.
>>>>>
>>>>>Any help appreciated.
>>>>
>>>>If you're doing tableupdate and there are many changes, you may be running out of locks in Novell. I forget what the setting name is, but you usually have to update the total system locks available to Novell.
>>>
>>>
>>>This particular program does a massive update to to table and does use table update.
>>>
>>>Is there a way of determining if running out of Novell locks is the problem?
>>>What are my options to fix the problem?
Regards N Mc Donald