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