>I have a Windows 2.6 multi-user application on Novell. During a specific piece of code I create a table and save it on the users local C drive Temporary folder. The table was created with an SQL select statement but to prevent any possible exceptions I now take the cursor return from the SQL and physically do a COPY TO to create this table in the C: temp folder (Yes that folder is there).
>
>I then create a Browse Window to display the contents of the table and allow the users to change the contents of one of the fields. This works fine for single user. If multiple users are displaying this Browse Window - some of the machines and only some of the machines will get a Unable to Lock Record message when trying to display that browse window.
>
>Is it something in Novell that is doing this as some of the machines are working fine.
>
>Help,
>Thanks,
>Pete

I assume that when they are doing this the file is back on the net. Be sure that exclusive is set off before you open the table for the browse. Note that we have found some problems with Novell ver. 4.x and FoxPro. Also note that you WILL have problems with file and record locking if you are running Segate Backup Exec on the server and Novell Ver. 4.x. Best to upgrade to Novell 5.0. I just found that it also helps to run the latest Novell shell 3.1.

Let me know if this helps or not. We have seen similar strange problems.