Compact and Repair

  • Thread starter Thread starter HagridWTL
  • Start date Start date
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!.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compact and Repair Database? 4
Compact and Repair 12
Compact & Repair Question 1
Compact & Repair 14
Compact and Repair Advice 14
compact and repair 6
Compact and Repair Freezes 1
compact and repair when database is split 10

Back
Top