Compact and repair

[troy_s11]

I have deleted a lot of imformation from a database that has gotten
large. After deleting the data, I did a compact and repair thinking
it would reduce the size of the database. It doesn't change the size
at all. Any help would be appreciated.

[Chris O'C via AccessMonster.com]

Could it be that you're compacting the front end of a split database, which
doesn't compact the back end?

Chris
Microsoft MVP
tr******@hotmail.com wrote:

>I have deleted a lot of imformation from a database that has gotten
large. After deleting the data, I did a compact and repair thinking
it would reduce the size of the database. It doesn't change the size
at all. Any help would be appreciated.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200805/1

[troy_s11]

I haven't split any databases. I didn't have any problems before when
I used XP with Access 2003. Now I have Vista with Access 2007 SP1.

On May 20, 10:28*am, "Chris O'C via AccessMonster.com" <u29189@uwe>
wrote:

Could it be that you're compacting the front end of a split database, which
doesn't compact the back end?

Chris
Microsoft MVP

[e-mail] wrote:

I have deleted a lot of imformation from a database that has gotten
large. *After deleting the data, I did a compact and repair thinking
it would reduce the size of the database. *It doesn't change the size
at all. *Any help would be appreciated.

--
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2008...

[Chris O'C via AccessMonster.com]

How much is "a lot of information"? I expect that you mean many MB of data
but I have to ask, is it less than 4 KB? Each data page holds 4 KB, but if
it's only partially filled with data, the whole 4 KB of disk space is
allotted to the file and a compact won't diminish the file size.

If it's many MB of data you've deleted, you may need to use the /decompile
switch to open the db, then compile and compact. Actually, that would work
on earlier versions of Access when the db is bloated. I'm not sure if the
/decompile switch works with Access 2007, or if it even works on accdb files.
Try the /decompile switch on a copy of your db.

Example to put in a Windows shortcut's target (all one line):

"C:\Program Files\Microsoft Office\OFFICE12\Msaccess.exe" "C:\db.mdb"
/decompile

Chris
Microsoft MVP
tr******@hotmail.com wrote:

>I haven't split any databases. I didn't have any problems before when
I used XP with Access 2003. Now I have Vista with Access 2007 SP1.

>Could it be that you're compacting the front end of a split database, which
doesn't compact the back end?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200805/1