• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 937
  • Last Modified:

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

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

3 Solutions

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: http://support.microsoft.com/default.aspx?scid=kb;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.
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.
-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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now