Results 1 to 7 of 7
  1. #1
    boywonder is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Dec 2010
    Location
    Memphis, TN
    Posts
    60

    Loop and Max. storage corrupted db

    I made a mistake and did a loop and it got to the maximal storage of Access 2003 and now it is giving me this error msg everytime I tried to go to the Event Procedure:

    'MS Office Access has detected corruption in this file. To try to repair the corruption, first make a backup copy of the file. Then, on the Tools menu...'

    I can not repair and compact because it gives me the above error and I have deleted the table with the 9M records and it still gives me the above error.

    Does anyone know what I need to do to recovery my code. It was a lot of code and I do not want to start over.

    HELLLLLLLLLLLPPPPPPPPPP!!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Have you tried *importing* everything into a fresh, new db? http://www.btabdevelopment.com/ts/impnew

  3. #3
    boywonder is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Dec 2010
    Location
    Memphis, TN
    Posts
    60
    yes, I tried that and it still gives me the above msg...

  4. #4
    boywonder is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Dec 2010
    Location
    Memphis, TN
    Posts
    60
    My file size is 2GB and is a MS Access 2003 database.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It may not help but have you tried JetComp? http://support.microsoft.com/kb/295334

  6. #6
    boywonder is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Dec 2010
    Location
    Memphis, TN
    Posts
    60
    Nope, didn't work. I don't understand. I can open the db in design, open the form in design, but can not run the db.

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Sorry but that is my bag of tricks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access is Corrupted
    By waqas in forum Forms
    Replies: 4
    Last Post: 10-16-2011, 01:23 PM
  2. Help!! - Corrupted Module
    By rcrobman in forum Modules
    Replies: 3
    Last Post: 04-29-2011, 03:37 PM
  3. General Storage Advice
    By GraemeG in forum Access
    Replies: 1
    Last Post: 03-13-2011, 02:01 PM
  4. Corrupted Database
    By evander in forum Access
    Replies: 1
    Last Post: 04-29-2010, 12:58 PM
  5. PDF Storage
    By slash75 in forum Access
    Replies: 0
    Last Post: 04-18-2007, 02:51 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums