12-13-2002, 11:26 PM
I need to use a DAO connection to my database, and there are about 5 people accessing this database at one time. The problem that I am running into is that the computers are extremely slow and when queries are performed to the database by more than one user, an error occurs because the queries take too long to perform. I set the Number of update retries in acceess to 10(max), and the Update retry interval to 1000 msec(max), and it still times out because the queries take too long on the slow computers.
Is there anything I can do in VB that would not time out, and it would wait until the database is ready?
I appreciate any help
12-14-2002, 01:51 AM
I will not say anything special but still... I have experienced kind of the same problem. They also say that 5-6 simultaneous usets is enough to cause a trouble (though it's always arguable but mostly seems to be true)...
Just out of curiousity:
- how big are the tables (width/depth)?
- what kind of quiries are that?
- you are sure you've indexed the fields?
12-14-2002, 10:07 AM
The table have about 65,000 records, and they are about 12 columns wide with 25 characters each on average. Yes I have indexed them. The queries that I am trying to perform are simila rto this:
strSQL = "SELECT MEMBR, LNAME, FNAME, MI, STATN, SEQNM, NAMECOD, TITCOD, ESALU, " & _
"MNAME FROM Members WHERE LNAME >= '" & memberlastnametxt & "' AND FNAME >= " & _
"'" & memberfirstnametxt & "' ORDER BY LNAME, FNAME"
Is there anything you know in VB that can help with the timing out issue?
12-14-2002, 11:22 AM
The database is not large. YOu need to compact it regularly.
The PC is not slow. Your network connection is slow instead.
You may place the database on a fast machine on network,
and have good cables as well as good LAN server.
Try to open or get recordset with ReadOnly Cursor that
works the fastest.