Compact and Repair

H

HagridWTL

Help please!

We recently ran a compact and repair on our access 2002 database. Since
running the compact and repair the overall database performance is very slow
and executing queries that use user input no longer work (user enters
information on a form and hits a command button to submit the query).

Any ideas or help wouldn't be greatly appreciated

Thanks!.
 
A

Arvin Meyer

I assume that you have split the database and put a copy of the front-end on
each workstation. If not, make a copy, split the database, run a Comapact
and repair on each part and put a copy of the front-end on each workstation.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top