I am using A4v6.22 to run a business database that creates and stores our invoices and Manufactures orders. The invoicing database has close to 30,000 records, and the Order database has near 23,000 records. So I am no where near any record limits..
The databases resides on an NT server, and each Windows 98 network client runs their own copy of the A4V6Runtime to access the databases. The server does nothing else but hold these databases. there are no other programs or data stored on the server, and nothing else to take up processor time. The only clients that access this server (about 15) are the ones running A4v6Runtime. Most of the time there is usually only 4 or 5 people acdcessing the databases at the same time the rest are idol.
Now the problem. From time to time just about everyones computers go into a waiting mode all at once. A4 says WAITING at the bottom of the A4 screen. Kind of like the file locking mode, but it just says waiting, but does not tell us why. There might be 1 or 2 computers that are still accessing fine but the rest are waiting.. The waiting can last for several minutes up to 10 mins.. and Finally they will come back and everything runs fine till the next time it happens. Lately it has been happening more and more often like from 2 times a day to sometimes only every 2 days or so.. Sometimes we get tired of waiting 5 or 10 mins, and shut down all the computers on the network and reboot the server.. then it seems fine again for a few days.. but it always happens again.. I have tried reindexing but it does not seem to help.
How Can I tell what the heck it is doing, and why it goes into the waiting screen???? And what causes it to go into a WAITING screen. Has this happened to anyone else??? Is there a way that it can be fixed so it won't do that?? If I just knew what it was doing while everyone is waiting I might understand.. But it is hard to tell the customer that is standing in front of you that the computer is in a waiting mode, so I can't do your invoice for you..
There has to be a solution for this..
ANY IDEAS!!
Help,
Terry
The databases resides on an NT server, and each Windows 98 network client runs their own copy of the A4V6Runtime to access the databases. The server does nothing else but hold these databases. there are no other programs or data stored on the server, and nothing else to take up processor time. The only clients that access this server (about 15) are the ones running A4v6Runtime. Most of the time there is usually only 4 or 5 people acdcessing the databases at the same time the rest are idol.
Now the problem. From time to time just about everyones computers go into a waiting mode all at once. A4 says WAITING at the bottom of the A4 screen. Kind of like the file locking mode, but it just says waiting, but does not tell us why. There might be 1 or 2 computers that are still accessing fine but the rest are waiting.. The waiting can last for several minutes up to 10 mins.. and Finally they will come back and everything runs fine till the next time it happens. Lately it has been happening more and more often like from 2 times a day to sometimes only every 2 days or so.. Sometimes we get tired of waiting 5 or 10 mins, and shut down all the computers on the network and reboot the server.. then it seems fine again for a few days.. but it always happens again.. I have tried reindexing but it does not seem to help.
How Can I tell what the heck it is doing, and why it goes into the waiting screen???? And what causes it to go into a WAITING screen. Has this happened to anyone else??? Is there a way that it can be fixed so it won't do that?? If I just knew what it was doing while everyone is waiting I might understand.. But it is hard to tell the customer that is standing in front of you that the computer is in a waiting mode, so I can't do your invoice for you..
There has to be a solution for this..
ANY IDEAS!!
Help,
Terry
Comment