Access 2003 Repairs but doesn't Compact

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Mikal via AccessMonster.com
    #1

    Access 2003 Repairs but doesn't Compact

    Good Afternoon,
    I have an A2K backend database which suffers fairly frequent corruption (yes,
    I do make frequent backups). If I open it in Access 2000 and compact and
    repair it the file is repaired and looses a good bit of bulk. However, If I
    do the same thing in Access 2003 the repair takes place but the file size
    remains unchanged.

    Just curious if anybody else has experienced this.

    I am Running Access 2003 in WinXP. Access 2000 is via Citrix and for all I
    know the OS might be NT 4.0
    Thanks,
    Mike

    --
    Mike Pippins

    "We have met the enemy and he is us." -- Pogo Possum

    Message posted via AccessMonster.c om
    http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1


    Tags: None
    • Allen Browne
      #2
      Re: Access 2003 Repairs but doesn't Compact

      Especially as you are opening it under different versions here, a decompile
      might fix it.

      Standard recovery/maintenance steps:
      Microsoft Access tips: Standard recovery sequency
      http://allenbrowne.com/recover.html
      Techniques for recovering and repairing a Microsoft Access database


      --
      Allen Browne - Microsoft MVP. Perth, Western Australia
      Tips for Access users - http://allenbrowne.com/tips.html
      Reply to group, rather than allenbrowne at mvps dot org.

      "Mikal via AccessMonster.c om" <u16180@uwewrot e in message
      news:864f5b00db da0@uwe...
      Good Afternoon,
      I have an A2K backend database which suffers fairly frequent corruption
      (yes,
      I do make frequent backups). If I open it in Access 2000 and compact and
      repair it the file is repaired and looses a good bit of bulk. However, If
      I
      do the same thing in Access 2003 the repair takes place but the file size
      remains unchanged.
      >
      Just curious if anybody else has experienced this.
      >
      I am Running Access 2003 in WinXP. Access 2000 is via Citrix and for all
      I
      know the OS might be NT 4.0

        Comment

        • Mikal via AccessMonster.com
          #3
          Re: Access 2003 Repairs but doesn't Compact

          Allen Browne wrote:
          >Especially as you are opening it under different versions here, a decompile
          >might fix it.
          >
          >Standard recovery/maintenance steps:
          http://allenbrowne.com/recover.html

          Thank you very much. That looks pretty straight-forward. I'll give it a try
          when I get back to work.
          Mike

          --
          Mike Pippins

          "We have met the enemy and he is us." -- Pogo Possum

          Message posted via AccessMonster.c om
          http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1


            Comment

            Previous template Next
            Working...