Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004
    Location
    Fort Worth, TX
    Posts
    43

    Unanswered: Compact/Repair Problem

    I am haveing issues with the Compact/Repair Function for a Dbase that I have created. Background:
    I have a Dbase that I built that exists on a network drive by muttiple users. (I am a novice Acess User) Every once in a while the file size gets really big (365 MB from and original 57 MB) I have been running the Compact/Repair function for a while with no errors.

    Now I try to run it and the screen goes black as always during the process but when the the progress bar only show 3 "dots" the main menu form returns and I am able to use the system. It is not compacted (the file size has not changed.)

    I have made sure that there are no users in the dbase upon running this.
    What could cause this error and how do I fix this? The file is now around 500 MB. (10 times it's usual size)

  2. #2
    Join Date
    Nov 2005
    Location
    Jersey
    Posts
    47
    That's happened to me once and it was because there was no room on the drive to compact the database.
    Copy the database to another location - compact it - then turn on the compact on close option from the Tools - Options - General tab. This way you don't have to worry about it.

    I hope this helps.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,420
    Provided Answers: 7
    Odaniels Works That what happen to me to

    But One thing I have done
    Yes turn on the compact on close (Back end database)
    Create a Autoexec macro to close Quit the Program

    Then I have a Scheduled Task That Run @ 2.00am every day that open te database the macro Close it the compact on close kick in job done. LOL
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •