PLEASE HELP ME!!!

[hotsauce]

My application runs through a network with an NT server and 5 win95 clients. I am using ADO. My application is running very slow when trying to access the database from the server. I am currently using Microsoft Access 97. There is a 1-5 second delay evertime I try to write or access information. I have already tried compacting and repairing the db. Please Help! Thank You!!!

[Edneeis]

make sure you use indexes as much as possible that will speed things up quite a bit. Avoid using queries with too many multiple tables. Try a disconnected recordset, (I don't really know if that will help or not).

[VodkaVic]

A couple of things that may help.

Firstly their are some performance issues using Access97 (jet 3.5) databases with ADO. You would be best to upgrade the Access Database to Access2000 (jet 4.0) this should speed things up a bit. You may need service pack 4 for vb6 as older versions of vb6 were not compatible with Access2000.

Secondly the more bound controls you have will slow things down. Controls like bound grids and list boxes are prime contenders. Code that executes whilst data is loaded into these type of controls during events like row/sel change/fetch needs to be kept to a minimum. Recordsets from joined tables will also slow things down, ensure you are linking on long integers whereever possible and keep these fields indexed. Don't go overboard with your indexing though, each index in your table create slightly more overhead each time your app saves a record.


It might also be worth checking its not a network problem rather than your app.