General discussion
March 9, 2003 at 05:15 PM
piyushmittaluts

Slow MS Access during search query

by piyushmittaluts . Updated 23 years, 6 months ago

I have 5 users working on a shared database in MS Access.. The number

of rows in the database is now 17k and very soon it will get double

from present number.

Now the problem is we are finding the database very slow when some

searchquery is given. To rectify this problem we have made the MDE

file of the database… removing the design code from the forms. but

there is only little improvement over the performance..

Plz don’t tell to compact and repair option of the database as we are

doing this daily (4-5 times).

Thanx in advance.

Piyush

This discussion is locked

All Comments