Chuck Norris said:
How do i Compact and repair databases?
You're not Chuck Norris.
Chuck Norris was born knowing how to compact and repair a database.
Just kidding. Different versions have slightly different directions.
Basically from the menubar
Tools >>> Database Utilities >>> Compact and Repair
If you already have a corruption problem:
First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.
Download a copy of JetComp.exe:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956
Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:
http://www.datastrat.com/Code/DocDatabase.txt
Also have a look at the Microsoft KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137
Then have a look at Tony Toews' Access Corruption FAQ at:
http://www.granite.ab.ca/access/corruptmdbs.htm
for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.
Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:
http://www.pksolutions.com