MS-Access 2007 - Compact & Repair how?

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
--
Russ at scaninc.org

Office button, Access Options, Manage
-TedMi

"Tech Express" wrote in message
...

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
--
Russ at scaninc.org

Click the Office button (top left in A2007.)

Compact/repair is under Manage.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tech Express" wrote in message
...

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
--
Russ at scaninc.org

Thank you
--
Russ at scaninc.org


"Allen Browne" wrote:

Click the Office button (top left in A2007.)

Compact/repair is under Manage.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tech Express" wrote in message
...

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
--
Russ at scaninc.org

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.


"TedMi" wrote in message
...
Office button, Access Options, Manage
-TedMi

"Tech Express" wrote in message
...

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

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