MS-Access 2007 - Compact & Repair how?

[Tech Express]

Is that option that was in 2003 still available ?

I have some corruption on a DB. A big table I cannot get to export. I have
used the compact and repair in the past with MS-Office 2003 with success. I
would like to do a similiar process with MS-Office 2007 Access.

Russ at Scaninc.org

 

[TedMi]

Office button, Access Options, Manage
-TedMi

 

[Allen Browne]

Click the Office button (top left in A2007.)

Compact/repair is under Manage.

 

[Tech Express]

Thank you
--
Russ at scaninc.org

Click the Office button (top left in A2007.)

Compact/repair is under Manage.

 

[vanzandt]

Make sure you compact/repair a copy of your database, not the original.
In case something goes bad, you can try again on another copy of the
original and keep the original intact for recovery.

 

[aaron.kempf]

Yah, if you've got corruption, it basically means

NEENER-NEENER, you're a ****ing idiot for using Jet

Move to SQL Server

Anyone using Jet for any reason (and subjecting your customers to
corruption) should be FIRED and then SPIT UPON.

-Aaron

 

[HH]

I found out that the compact function in Access 2007 does not really
help. Try "Save in another format" via the Office Button and select
Access 2007 as format. It seems this will compact your application to
it's absolute minimum.

Attention, do not to to overwrite the original file, because then you
will lose everthing!!!