If you test these values immediately before the code fails, what do you get?
WAIT WINDOW SET('exclusive')
WAIT WINDOW SET('multilocks')
wait window used('mytable')
wait window dbc()




can you post the line of code where the error is failing and describe where the error is occurring and describe where the code is located in your form?
- opening the table manually in the beforeopentables of the DE?
- possibly, you have a control on the form that is using the table
before you are running your code to open? (grid or listbox)





>I've also discovered that, despite being logged in as administrator and despite the fact that I took out the requirement to open the file exclusively, the user still can't open the file. It is still throwing error 3 - file is in use. But I had him immediately go to Windows Explorer and he was able to rename the file with no problem. Arrrggghhhh . . .
>
>>Just a thought...
>>
>>You may try having the client log in using an administrator status and test your result. We have run into a few scenarios on different networks that do not seem to respond correctly. (we have a few users running novell for example)
>>
>>Operating system profiles can be corrupted if the user is logging in to winXP and win2000 at different times...
>>
>>
>>>I'm running into a strange situation at a client's site. I'm simply trying to open a file exclusively and getting an error 3 - File is in use. Yet the file is not in use. We've done a few things to confirm this. First, we were able to rename the DBC with no problem. Second, we were able to rename the file itself with no problem. And, third, Windows did not list the file as being open. Yet when the form that uses this file is opened, we get error 3. It works fine on my local machine when running it locally and when running it off the network. I've not run into this before - it's kind of strange. Anyone seen anything like this?
>>>
>>>Russell Campbell