MS-Access 2007 - Compact & Repair how?

T

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
 
A

Allen Browne

Click the Office button (top left in A2007.)

Compact/repair is under Manage.
 
V

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.
 
A

aaron.kempf

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

NEENER-NEENER, you're a fucking 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
 
H

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!!!
 

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

Top