Results 1 to 12 of 12
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Repair a BackEnd (2000)

    Hi,

    We have a corrupt backend.

    When we try to do a compact and repair in access (it asks you as soon as you open the backend) it gets so fat, access develops a error and then closes)

    We then try to use the JetCompact utility again the same happens.

    I have found a peice of software on the internet:

    http://www.nucleustechnologies.com/Access-...ir-Software.php That seems to be able to open it, tells you how it can fix it, but wants 300USD for the privilige.

    Any ideas?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Repair a BackEnd (2000)

    First of all, is it Access 2000 you're using or some other version with the Access 2000 file format?

    How big is the file you're trying to compact? Have you tried creating a new database and importing tables from that backend? That can sometimes identify the specific tables that have problems and steps can be taken to salvage the rest of the tables before you try to deal with the problem tables.

    What do you mean "it asks as soon as you open the backend"? Is there code in this backend or do you mean your frontend pops up a message when you try to attach to or use the backend?
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repair a BackEnd (2000)

    The message I get when I try to open the backend directly is attached.

    It only gets so far during the compacting and exists access causing an error. We are using Access 2000.
    Best Regards,

    Luke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Repair a BackEnd (2000)

    As Charlotte wrote, try to import the tables from the corrupt backend into a blank new database.
    Of course, if you have a recent non-corrupt backup, it might be easier to go back to that instead.

  5. #5
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repair a BackEnd (2000)

    Managed to use the utility to repair it, however it has messed up every date field in the tables.

    Anything upto the 12th of each month it has changed the month round with the day, which is annoying, so a update query on each table?

    What is the best code to use? for each date field?
    Best Regards,

    Luke

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Repair a BackEnd (2000)

    I'd do the following:
    - Set your system to use US date format mm/dd/yyyy.
    - Run the utility again (on the original database, not on the one where the dates have already been converted)
    - Switch back to UK date format dd/mm/yyyy

  7. #7
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repair a BackEnd (2000)

    Thanks for the response, utility is on home pc, so will try it later tonight
    Best Regards,

    Luke

  8. #8
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repair a BackEnd (2000)

    That seems to have done the trick now, thanks a lot for your help (again).

    Out of interest how often should I compact and repair the backend?
    Best Regards,

    Luke

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Repair a BackEnd (2000)

    That depends on how intensively it is used. If it is used a lot, I'd compact it every night.

    Maintaining a backup cycle is even more important.

  10. #10
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Repair a BackEnd (2000)

    okay, thanks

    Can the backend be backed up whilst it is open on the front end side of things?
    Best Regards,

    Luke

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Repair a BackEnd (2000)

    It is possible, but it depends on the application. Some programs refuse to copy files that are in use.

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Repair a BackEnd (2000)

    Yes it can, but if you are updating anything at the time you may lose some info and maybe save a half updated backend. This may lead to corruption of the copied backend.

Posting Permissions

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