URGENT: How do i rebuild indexes in a .mdb file?

  • Thread starter Thread starter Riccardo
  • Start date Start date
R

Riccardo

Hi,
i have a .mdb file i cannot open anymore since axs
says "...index corrupted".
is there a simple way to rebuild them (i'm a medic, not a
technician)?
the file is 29MB big and i'm using axs 97 & 2000 (with the
same result).
could i get my patients list back again?..or will they die
at once?
someone told me axs is not capable to handle file this
large, is it dramatically true?
thanx 4 all
Riccardo
 
Make a copy of the file for a backup in case this doesn't work.

Open the file with the following command line:
"<path>\msaccess.exe" "<path>\MyDatabase.mdb" /excl /compact

If you do this in 2000 it will do both a repair and a compact. If you do it in 97, do a
repair first "/repair" then a compact. You will need to include command line options for
workgroup, user, and password if you normally use them to open the file.

As far as a 29MB file goes, that is a relatively small database. If your file size shrinks
considerably after the compact, you may want to consider doing the compact more often. To
do so with the database open go to Tools|Database Utilities on the menu bar.
 
precious!!!
it worked!
forgive my entusiasm but i did't believe it could ever
work this simply!
fabulous
thank you most of all for quick replying
all the best
Riccardo
-----Original Message-----
Make a copy of the file for a backup in case this doesn't work.

Open the file with the following command line:
"<path>\msaccess.exe" "<path>\MyDatabase.mdb" /excl /compa ct

If you do this in 2000 it will do both a repair and a
Click to expand...
compact. If you do it in 97, do a
repair first "/repair" then a compact. You will need to
Click to expand...
include command line options for
workgroup, user, and password if you normally use them to open the file.

As far as a 29MB file goes, that is a relatively small
Click to expand...
database. If your file size shrinks
considerably after the compact, you may want to consider
Click to expand...
doing the compact more often. To
 
Using Access got to 'Database Utilities' then 'Compact
and repair Database'

that will rebuild your indexes

Best regards

Barry
 
Back
Top