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

[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

 

[Wayne Morgan]

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.

 

[Guest]

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

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

 

[Guest]

Using Access got to 'Database Utilities' then 'Compact
and repair Database'

that will rebuild your indexes

Best regards

Barry