One of my clients is having trouble running our VFP6 application on his network. He has a mix of workstations, mostly Win98 and has been running successfully for a number of years, with multiple users concurrently accessing a shared databases. He uses Novell 5.3 with the latest Novell Client on his workstations.

He has recently added to his network some new machines with Windows XP Pro installed and found that he gets errors when trying to open the same databases from these new machines. I have tracked down where the error is occuring - here is the code what happens:

lcTabName =
lcTabtoOpen=lcProjPath+lcTabName+".DBF"
lcIdxtopen=lcProjPath+lcTabName+".CDX"
IF FILE(lcIdxtoOpen) AND FILE(lcTabtoOpen)
* everything ok up to here, but the next line causes a
* FILE ACCESS DENIED error
USE (lcTabtoOpen) IN 0 SHARED
* then obviously the SELECT fails because it isn't USE'd
SELECT (lcTabName)

Now this doesn't happen every time. When he switches on the machine
in the morning it works fine. But when he closes the program and runs it again later the error occurs. If he reboots he can usually (but not always) open it ok. The funny thing is that other users on Win98 can always open the databases and never get this error.


Can anyone shed any light on this?