Slow responce time in A2002 db

J

johnb

I have a db with 140 tables and 1038 forms queries and
reports + 200 pages of VBA. The tables are one backend
and the rest in a frontend. The question(s) are: is there
any benefit in splitting the BE into say 5 or 6 BE's?
Alternatively how do determine where the bottlenecks are?
This db is compacted daily.

TIA johnb
 
Top