Data Compression

[aMack]

I am getting complaints about our Access data system running slow.

How do I compress the Access 2007 Database?

Would that be the best option?

 

[Maurice]

Open the database. Go to the Officebutton and look for the option "Manege"
and from the given options choose "compact and repair"

hth

 

[aMack]

I do not see " Officebuton or any Manage option.

Is that correct for Access 2007?

 

[aMack]

Found it - never mind.

Thanks

 

[John W. Vinson]

I do not see " Officebuton or any Manage option.

Is that correct for Access 2007?

The "Office Button" is the big round medallion on the database window. It's
got a lot of good stuff hidden behind it...

 

[John Spencer]

As far as the database running slow goes, I doubt that this will help the speed.

Has the database always been slow? Or is this a new development?

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County