>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.
Just a SWAG - but does each system have its own FOXUSER resource file? Browse settings are stored in the FOXUSER table if the FPW Resource file is in use.
If you aren't using the Resource file, try adding a SET RESOURCE OFF to the application at the beginning to see if the problem disappears. If so and you don't need the resource file, leave the code in place.
If you do rely on the resource file, amke certain that each user has a private FOXUSER.BDF (you can control this from CONFIG.FPW; each station can set an environment variable FOXPROWCFG to point at its own CONFIG.FPW, which can specify the location for that station's FOXUSER file.
>
>Help,
>Thanks,
>Pete