General information
Category:
Coding, syntax & commands
Hi,
Our users have been experiencing a lot of File lock ups recently. The users query the database that is stored on the server and they do not edit/add any record.
They would be using the application without any problems and suddenly they would get a 'File access denied' error. After that they cannot query the database any more. The only thing we notice each time this happens is that atleast one table in the database or the .dbc file itself would have a different date from the rest of the files(all the tables are zapped and filled with new data by a program that runs at night - so all the tables will show the time they were modified each night).
I am trying to determine, how the date can be different on one file in the database. If this file has a date of 2:40 PM, the users start having problems around the same time, which leads me to think that the file with the new date has something to do with these error messages.
From what I know the probable reasons may be:-
1. The user did not exit the application correctly. He might have used Ctl_Alt_Del.
2. Coulld another application be causing this?
3. Many users are executing 'Select' queries on these tables at once. When there are many users doing this, can this be a problem?
I am trying to change the program to ensure that the users always go through the exit routine(make sure that they close all the tables), when they exit.
Also I am planning on maintaining a table that would have the username, password, timein and timeout for every user that uses this system. I hope that this might help us track the problem. Will I have problems when many users are trying to add records to this log table at the same time?
If any of you have any suggestions, please help.
Thank you.
Ria
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