Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2016
    Posts
    1

    Unanswered: Very important issue with Access 2003

    Hi all. Can anybody help me? Yesterday I work with my access file with necessary data for my work and today I can’t open it. The version of Microsoft Office is 2003. Windows 7. Thank you!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so go back to your last back
    re do the work from that last back up to the time you lost the db

    failing that you may be able to import most/some/all of all the objects into brand new empty db.

    failing that you may be able to recover some of the work using the decompile switch

    moving on from that you need to develop strategies to either eliminate this or reduce the impact
    ...first and foremost develop a backup plan, stick to it, periodically prove that backup works
    ...separate development and live access files. NEVER do deisgn or development work on live data
    ...separate data (tables and common / generic queries) from the user interface (code, form, reports and user specific queries). this is the so called back end / front end split. when deploying a fornt end ideally each user should have their own local copy of the front end pointing to the same data
    ...front ends should be deployed as encrypted (MDE or ACCDE format not MDB/ACCDB format), theis means users cannot open the application and make changes to it.
    ...make sure your proposed use meets with the limits of Access
    ...that means run over a local network
    ...no bigger than 2Gb
    ...ideally no more than 15..30 concurrent if you are using the default database engine JET as opposed to say a client server backend
    if its multi user make certain you the most appropriate form of record locking.

    ..Im sure there's other points you may need to consider, and no doubt someone else will be along to point out those I've missed
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2016
    Posts
    1
    Quote Originally Posted by Bondiana054 View Post
    Hi all. Can anybody help me? Yesterday I work with my access file with necessary data for my work and today I can’t open it. The version of Microsoft Office is 2003. Windows 7. Thank you!
    Hello, man! Maybe your file is corrupted or damaged.
    You can follow this steps trying to recover you file:

    Before doing anything else, make a copy of the corrupted mdb file while Access is NOT running, and without overwriting any earlier backups. This lets you try different approaches and sequences if necessary.
    Next, try the built-in repair utility. This very simple solution may work with corrupted indexes, and might even get rid of a corrupted object:
    • In Access 2010, click Compact and Repair Database on the Database Tools ribbon.
    • In Access 2007, click the Office button (top left), then Manage.
    • In Access 95 - 2003, choose Database Utilities from the Tools menu.
    If this does not work, try to use alternative programmes, for example:

    https://www.accessrepairtoolbox.com/ Access Repair Toolbox

Posting Permissions

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