Problem: You or another user may have unexpectedly quit Microsoft......

Posted on 2004-10-25
Last Modified: 2008-01-09
Dear All,

Hi All,
I am using Access 2000.
Suddenly the below said problem is coming to me.
You or another user may have unexpectedly quit Microsoft Access while a Microsoft Access database was open.
Do you want Microsoft Access to attempt to repair?

I don't know what's happening and i list the following attempts to recover that one.

1. restart my machine.
2. Try to repair but in vain
3.Office 200 service pack 3 updated.

Can u help me in this regard

Question by:babujegannathan
    LVL 41

    Accepted Solution


    1) Importing all of your database objects into a new database. If that doesn't work:
    2) Use Jet Compact to try to repair the database:;en-us;273956
    3) If that doesn't work, try /decompiling, but in this circumstance I doubt it would help.
    4) Restore from a backup.
    LVL 58

    Assisted Solution

    Sometimes, the database gets corrupted beyond the point of repair. The only solution I know is then to create a new database and import all objects from the corrupted one. This will fail for the faulty objetc(s) and crash Access. You need to restart *after* the corruped object and try to find the corrupted objects in older backups of the database.

    With complex projects, this happends fairly often at design time (e.g. modifying code that is actually running, etc.).

    Good Luck.
    LVL 36

    Assisted Solution

    -sometimes- you can import the damaged table(s) into excel, save and reimport into a clean mdb...
    -sometimes- you can connect to the table via odbc (not linked tables) and import the data into a new mdb


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT Security CISA, CISSP & CISM Certification

    Master the advanced techniques required to protect network resources from external threats with the IT Cyber Security bundle. Built around industry best-practice guidelines, the IT Cyber Security bundle consists of three in-depth courses.

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    884 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now