Major fiasco on my hands here. I was in the middle of updating a record
when the system halted, and the Access DB became non responsive. Eventually
I had to CTRL-ALT-DEL to close the application. When I tried to open the DB
again, the file has become corrupt and I get the error message "The
Microsoft Jet database engine cannot find the object "Databases". I
understand a database can become corrupt during an interrupted write to a
table but is there any way I can get this database open again? I have tried
the following.
- Tried to compact and repair. Failed. Same error message appears.
- Tried importing objects into a blank DB. Failed. Same error message.
- Tried using jetcomp utility. Failed. Error message.
Access is in Access 2002 format and I was using Access 2003 for processing.
Anyone know what I can do to recover this db? I have a backup from two days
ago however I do not want to lose two days of work.
Thanks.
4  2185 
"Big Time" <bi************@remove-for-spam-hotmail.com> wrote: Major fiasco on my hands here. I was in the middle of updating a record
when the system halted, and the Access DB became non responsive. Eventually
I had to CTRL-ALT-DEL to close the application. When I tried to open the DB
again, the file has become corrupt and I get the error message "The
Microsoft Jet database engine cannot find the object "Databases". I
understand a database can become corrupt during an interrupted write to a
table but is there any way I can get this database open again? I have tried
the following.
- Tried to compact and repair. Failed. Same error message appears.
- Tried importing objects into a blank DB. Failed. Same error message.
- Tried using jetcomp utility. Failed. Error message.
You've done the basics but there are a few more things you can try at the Corruptions
FAQ. 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
You might want to try Digital DBA
( http://www.kzsoftware.com/products/digitaldba), which monitors your
database for corruption and automatically repairs it. It can also do
other database administration tasks like nightly backup, compact, and
repair.
Tony Toews wrote: "Big Time" <bi************@remove-for-spam-hotmail.com> wrote:
Major fiasco on my hands here. I was in the middle of updating a
recordwhen the system halted, and the Access DB became non responsive.
EventuallyI had to CTRL-ALT-DEL to close the application. When I tried to
open the DBagain, the file has become corrupt and I get the error message "The
Microsoft Jet database engine cannot find the object "Databases". I
understand a database can become corrupt during an interrupted write
to atable but is there any way I can get this database open again? I
have triedthe following.
- Tried to compact and repair. Failed. Same error message appears.
- Tried importing objects into a blank DB. Failed. Same error
message.- Tried using jetcomp utility. Failed. Error message.
You've done the basics but there are a few more things you can try at
the Corruptions FAQ. 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
Tony Toews wrote: "Big Time" <bi************@remove-for-spam-hotmail.com> wrote:
Major fiasco on my hands here. I was in the middle of updating a
recordwhen the system halted, and the Access DB became non responsive.
EventuallyI had to CTRL-ALT-DEL to close the application. When I tried to
open the DBagain, the file has become corrupt and I get the error message "The
Microsoft Jet database engine cannot find the object "Databases". I
understand a database can become corrupt during an interrupted write
to atable but is there any way I can get this database open again? I
have triedthe following.
- Tried to compact and repair. Failed. Same error message appears.
- Tried importing objects into a blank DB. Failed. Same error
message.- Tried using jetcomp utility. Failed. Error message.
You've done the basics but there are a few more things you can try at
the Corruptions FAQ. 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 ro*******@aol.com wrote: You might want to try Digital DBA
(http://www.kzsoftware.com/products/digitaldba), which monitors your
database for corruption and automatically repairs it. It can also do
other database administration tasks like nightly backup, compact, and
repair.
Ah, a competitor to FMS and all the other similar products out there.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Vinay |
last post by:
Hi
I have a corrupt word file. I am able to open it with the code given below
tr
Dim pInfo As System.Diagnostics.ProcessStartInfo = New System.Diagnostics.ProcessStartInfo(
pInfo.UseShellExecute...
|
by: Filips Benoit |
last post by:
A particular form - always the same - sometimes becomes corrupt after
saving.
Error msg =
The expression On Open you entered as the event property settings produced
the following error:
A...
|
by: Dan |
last post by:
Hi, just ran into my first instance of a backend Access97 database not
compacting. I'm getting the "MSACCESS.EXE has generated errors.." message on
compact.
I've narrowed it down to the largest...
|
by: Annette Massie |
last post by:
I have an 2000 database that is getting corrupt many times a day. The
application is sittin on a network with about 5 users accessing it.
Most times I get a call with the user saying the...
|
by: Bungle |
last post by:
Hi There,
Does anybody know where i might be able to locate a tool/application that
can determine whether a Database is corrupt??
Also, can a bad network connection cause a corruption to a...
|
by: dixie |
last post by:
I have come across some code to walk through the records of a corrupt table
and copy it record by record to a new table. It comes from the MVPS.Org
site and is as follows.
-----------------------...
|
by: Marc Bartsch |
last post by:
Hi,
I use a delegate to call a method from my main GUI thread. This delegate
takes one of my business objects as a parameter. When I do a synchronous
call, it all works fine, but if I do an...
|
by: Fredo |
last post by:
I have an app that I'm writing to manage jpgs. Sometimes the photos are
corrupt. If I use something like ACDSee, it will show the image, but it will
have a note in the status bar that the image is...
|
by: rdemyan via AccessMonster.com |
last post by:
One of my users had a corrupt front end that wouldn't open.
My app is launched using a launching application (logon app). The logon app
has a button for downloading a "fresh" copy of the front...
|
by: iheartvba |
last post by:
Hi this is a query made using access query builder:
SELECT tblBank.BankID, Now() AS TimeRecd, Val(Right(nz(,0),3)) AS ConsID, "AutoCASH" AS RecUser, tblBank.Dt, Forms!frmRecCASHRunningBal!tbGroup...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
