Access Crashed and now can't open anymore! Help!

[Fish]

I have an Access applicaion I built for my buiness. Last week the
application crashed and I haven't been able to get it running again
since in any form.

Now every time I try to run the application I get the following
standard error.

"Microsoft Access has encountered a problem and needs to close. We are
sorry for the inconvenience."

Not sure if this makes any differnece but I do have the database
seperated in two mdb files, one with only the data and the other which
is the interface.

Does anybody have any tips as to what I can try to get it working
again?

Any tips &/or tricks welcome!

Thanks,

Quintus

[Big Time]

This happened to me a few weeks ago and unfortunately, the DB was corrupted
and I was unable to recover it. The DB became corrupted when the network it
was on crapped out while it was in the middle of a write operation. That
being said, there are a few things you can try:

1. Try to Compact and Repair the DB. Do this by opening the MDB with the
data and select Database Utilities > Compact and Repair Database.

2. Create a blank database and try to import the objects from either of
your MDB files.

3. Download the jetcomp utility from the Microsoft website and see if that
can help you repair the MDB files.

Hope one of these helps. I was lucky in that I only lost two days of work
and was able to restore from a backup. Hopefully you'll be able to mimimize
the damage.
"Fish" <qs******@gmail.com> wrote in message
news:10**********************@k17g2000odb.googlegr oups.com...

I have an Access applicaion I built for my buiness. Last week the
application crashed and I haven't been able to get it running again
since in any form.

Now every time I try to run the application I get the following
standard error.

"Microsoft Access has encountered a problem and needs to close. We are
sorry for the inconvenience."

Not sure if this makes any differnece but I do have the database
seperated in two mdb files, one with only the data and the other which
is the interface.

Does anybody have any tips as to what I can try to get it working
again?

Any tips &/or tricks welcome!

Thanks,

Quintus

[Salad]

Fish wrote:

I have an Access applicaion I built for my buiness. Last week the
application crashed and I haven't been able to get it running again
since in any form.

Now every time I try to run the application I get the following
standard error.

"Microsoft Access has encountered a problem and needs to close. We are
sorry for the inconvenience."
Can you provide more information? First, what steps have your performed
to debug/open the database? Do you have/have you made a copy of the
current database before you start messing around? Once you have a
copy, have you compacted/repaired? Have you attempted to create a new
database and import the objects into the new database? Can you get to
the database window? Are there certain forms, queries, etc that abort?
Can you open up your tables? Are your links broken between
front/backend? Is the crash intermittent? Are you using ODBC in your
table links?

Not sure if this makes any differnece but I do have the database
seperated in two mdb files, one with only the data and the other which
is the interface.

Does anybody have any tips as to what I can try to get it working
again?

Any tips &/or tricks welcome!

Thanks,

Quintus

[Tony Toews]

"Fish" <qs******@gmail.com> wrote:

Does anybody have any tips as to what I can try to get it working
again?

For more information on corruption including possible causes, determining the
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[Tom van Stiphout]

On 21 Sep 2004 11:33:41 -0700, "Fish" <qs******@gmail.com> wrote:

The simplest solution is to restore a backup.
Tony Toews has a good web page about this subject. I'm sure Google can
find it for you.

-Tom.

I have an Access applicaion I built for my buiness. Last week the
application crashed and I haven't been able to get it running again
since in any form.

Now every time I try to run the application I get the following
standard error.

"Microsoft Access has encountered a problem and needs to close. We are
sorry for the inconvenience."

Not sure if this makes any differnece but I do have the database
seperated in two mdb files, one with only the data and the other which
is the interface.

Does anybody have any tips as to what I can try to get it working
again?

Any tips &/or tricks welcome!

Thanks,

Quintus