Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2009
    Location
    Gatineau, Quebec Canada
    Posts
    147
    Provided Answers: 1

    Unanswered: Compact and Repair Database

    Hi all,

    My 4.7 meg Access 2003 database (school marks and absences) after, I think, a database problem (I was foolishly doing some development on my production version), turned into a 2.9 meg database. Terror! However, all the data seems fine (I did a bit of testing with backups). It looks as if the database spontaneously did a "Compact and Repair" (which would account for it almost halving in size). The only other thing of note is that students have a lot of viruses on classroom computers, and perhaps one snuck by my virus checkers (however, I practice "safe" computing, using a flashdrive with a lock switch to transfer data to suspect machines).

    Anyone noticed this kind of behavior (Access spontaneously triggering "Compact and Repair" before?

    Regards


    John M. Smith
    (Currently) Guangxi University,
    Nanning. China

  2. #2
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by praxis1949 View Post
    Hi all,

    My 4.7 meg Access 2003 database (school marks and absences) after, I think, a database problem (I was foolishly doing some development on my production version), turned into a 2.9 meg database. Terror! However, all the data seems fine (I did a bit of testing with backups). It looks as if the database spontaneously did a "Compact and Repair" (which would account for it almost halving in size). The only other thing of note is that students have a lot of viruses on classroom computers, and perhaps one snuck by my virus checkers (however, I practice "safe" computing, using a flashdrive with a lock switch to transfer data to suspect machines).

    Anyone noticed this kind of behavior (Access spontaneously triggering "Compact and Repair" before?

    Regards


    John M. Smith
    (Currently) Guangxi University,
    Nanning. China
    Is you database split into Application (front end) and Data (back end)?

    If not, I would recommend that you do this.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Do you, by chance, have Compact on Close checked? You can check by going to Tools - Options - General. Something may have temporarily bloated the db and then the Compact shrank it noticeably. Using this option is a very bad idea, in my opinion, as Compacting itself is frequently cited as a cause of corruption, and should never be done without making a back up copy of the db first.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Mar 2009
    Location
    Gatineau, Quebec Canada
    Posts
    147
    Provided Answers: 1

    Database Compacted Itself?

    Hi,

    Thanks for your observation, but I checked, and the option you mentioned is not checked. Pretty frightening, especially when one is coming to the end of a school year, and all ones marks are tied up in the program.

    With two weeks to go in China (and one week before I must publish the marks), I am sitting on a computer that seems to have problems and a customized Access program that is doing strange things. I back up the database EVERY time I change it (on a flash drive AND via gmail). Though this is China (and thus we should not believe in God), pray for me!

    Regards

    John S
    Current Guangxi University
    Nanning China



    Quote Originally Posted by Missinglinq View Post
    Do you, by chance, have Compact on Close checked? You can check by going to Tools - Options - General. Something may have temporarily bloated the db and then the Compact shrank it noticeably. Using this option is a very bad idea, in my opinion, as Compacting itself is frequently cited as a cause of corruption, and should never be done without making a back up copy of the db first.

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Be aware that the Access Gnomes do not like flash drives! I have read literally dozens of cases of databases stored on them becoming corrupt! One suggestion for this is that they prematurely report the transfer from the PC to the flash drive as being complete, with the suggestion that you wait an extra 30-60 seconds after the reported completion before disconnecting.

    Linq
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    Join Date
    Mar 2009
    Location
    Gatineau, Quebec Canada
    Posts
    147
    Provided Answers: 1

    Flash Drives

    Thanks a ton -- that is good to know. I will keep saving on the flashdrive AND over the Internet. And keep praying!

    Regards

    John S

Posting Permissions

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