General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why does Fox stop responding when opening a table?
Any ideas why one of the two lines would *occassionally* cause FoxPro v5 to stop responding?
lnFileExist = adir( laFileList, "\\charlton1\apps\mastfile\data\produnit.dbf" )
use ProdUnit in select( "ProdUnit" ) shared
We have a very simple application which is run by upto 100 different people through the day, but typically only 13 would have it open at any one time. Over 300 searches are performed per day, so its not up there with high demanding Web sites.
Sometimes when people start the software FoxPro appears to stop responding. I would typically put it down to Windows, but..
Date/Time-------- USER COMMENT
27/10/00 14:10:17 prw - \\charlton1\apps\mastfile\data\produnit.dbf
27/10/00 14:10:53 prw - \\charlton1\apps\mastfile\data\produnit.dbf
27/10/00 14:11:31 prw - \\charlton1\apps\mastfile\data\produnit.dbf
27/10/00 14:14:51 clj - \\charlton1\apps\mastfile\data\produnit.dbf
27/10/00 14:48:31 prw - \\charlton1\apps\mastfile\data\produnit.dbf
The log shows that not only did PRW have problems, but so did CLJ. What could cause this to happen? They were obviously still able to log the fact that they were attempting to open the table (The log is store on another server)
What I'm basically after is a few hints to eliminate this problem. The software works well in the majority of cases, its just the odd balls which causes a few users some problems that may encourage them to stop using the program. I would like to help them, if I can.
Regards
Jason
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only