Compact and repair

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • troy_s11@hotmail.com
    #1

    Compact and repair

    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.
    Tags: None
    • Chris O'C via AccessMonster.com
      #2
      Re: Compact and repair

      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_s11@hotmai l.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.c om
      http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200805/1


        Comment

        • troy_s11@hotmail.com
          #3
          Re: Compact and repair

          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.c om" <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_...@hotmai l.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.c omhttp://www.accessmonst er.com/Uwe/Forums.aspx/databases-ms-access/2008...

            Comment

            • Chris O'C via AccessMonster.com
              #4
              Re: Compact and repair

              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


              troy_s11@hotmai l.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.c om
              http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200805/1


                Comment

                Previous template Next
                Working...