Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why does Fox stop responding when opening a table?
Message
From
31/10/2000 07:43:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why does Fox stop responding when opening a table?
Miscellaneous
Thread ID:
00436272
Message ID:
00436272
Views:
57
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
Map
View

Click here to load this message in the networking platform