By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,964 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,964 IT Pros & Developers. It's quick & easy.

Compact and repair

P: n/a
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.
Jun 27 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jun 27 '08 #2

P: n/a
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

troy_...@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.comhttp://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/2008...
Jun 27 '08 #3

P: n/a
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

Jun 27 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.