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 database?
Thanks in advance for any help,
Bungle 9 2452
Whenever I have a database that can't be repaired using the built in
"compact and repair" menu option, I consider the database corrupt.
Have you tied "compact and repair"?
You might also try creating a blank database and importing the tables
from the corrupt database into the new database (File/Get External
Data/Import).
There are companies who specialize in the recovery of data from
corrupted databases.
I know of one who guarantees 2 hour service, although I have not yet had
the opportunity to try their services.
Yes...a bad network connection might corrupt your database.
Cheers!
Mike
Bungle wrote: 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 database?
Thanks in advance for any help,
Bungle
sfdskf'; wrote: You might also try creating a blank database and importing the tables from the corrupt database into the new database (File/Get External Data/Import).
There are companies who specialize in the recovery of data from corrupted databases.
ironic, since in all likelihood they do *precisely* what you mention,
i.e. they just import all the objects from teh corrupt .mdb and then
rename the copy, ship it off to the gullible client, and charge them a
very nice fee for about seven minutes' work that the client could have
easily done themselves.
:(
--
Terrell Miller mi******@bellsouth.net
"Every gardener knows nature's random cruelty"
-Paul Simon RE: George Harrison
Terrell Miller wrote: ironic, since in all likelihood they do *precisely* what you mention, i.e. they just import all the objects from teh corrupt .mdb and then rename the copy, ship it off to the gullible client, and charge them a very nice fee for about seven minutes' work that the client could have easily done themselves.
Your evidence is ...?
--
--
Lyle
Terrell Miller <mi******@bellsouth.net> wrote: There are companies who specialize in the recovery of data from corrupted databases.
ironic, since in all likelihood they do *precisely* what you mention, i.e. they just import all the objects from teh corrupt .mdb and then rename the copy, ship it off to the gullible client, and charge them a very nice fee for about seven minutes' work that the client could have easily done themselves.
:(
Some may do such. Others get much more detailed and have written their own code to
examine the structure of MDBs.
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: There are companies who specialize in the recovery of data from corrupted databases.
ironic, since in all likelihood they do *precisely* what you mention, i.e. they just import all the objects from teh corrupt .mdb and then rename the copy, ship it off to the gullible client, and charge them a very nice fee for about seven minutes' work that the client could have easily done themselves.
:(
Some may do such. Others get much more detailed and have written their own code to examine the structure of MDBs.
I'm sure they do, but what's the point?
When I was a consultant the senior guy on our team came to me one day.
One of his clients had a corrupt .mdb, he'd been going over it for the
last hour, and he wanted my advice on whether we could reset a registry
entry or recopy a dll or such.
When I told him just to open a blank database, import all the objects
from the corrupt file, delete the corrupt one and rename the new
database, he got *pissed*. Consultants don't do things like that, they
look for excuses to waste several (billable) hours coming up with some
overcomplex solution that makes them look clever.
So he diddled around with the broken .mdb for a long time, then finally
gave up and turned it over to me. It took me all of four minutes to do
precisely what I had suggested in the first place.
Meanwhile the client is sitting there with this "are you guys through
*now*?" glare on his face.
--
Terrell Miller mi******@bellsouth.net
"Every gardener knows nature's random cruelty"
-Paul Simon RE: George Harrison
Terrell Miller wrote: sfdskf'; wrote:
You might also try creating a blank database and importing the tables from the corrupt database into the new database (File/Get External Data/Import).
There are companies who specialize in the recovery of data from corrupted databases.
ironic, since in all likelihood they do *precisely* what you mention, i.e. they just import all the objects from teh corrupt .mdb and then rename the copy, ship it off to the gullible client, and charge them a very nice fee for about seven minutes' work that the client could have easily done themselves.
If they know how to do it. Or it was possible to recover it that way.
I like it when I can charge £500 to change 1 line of code, sounds
ludicrous but here's a breakdown:
Change 1 line of code: £1
Knowing exactly which line to change: £499
;-)
--
This sig left intentionally blank
I have seen several, perhaps 20, corrupted mdb files. I have restored
some. In none of the cases, did a simple import of all the objects into
a new db effect a complete recovery.
In almost all these cases the db has lost contact with a table; the
pointers to the table are gibberish, or point to gibberish. In this
situation one cannot import the table to another db.
I have had some success with creating a new db and table with the same
structure as the corrupted table, and adding more records than the
corrupted table had, (or a few million when I did not have this
information). The I have done a direct hex copy of the pages from the
corrupted file that seemed to contain the corrupted table's data into
the new table's file. Then I have imported the other "good" objects and
run some code on the repaired table to remove junk records, those that
grabbed bytes that were clearly not legitmate. This seemed to work a
couple of times, but it was not fool-proof and it was very
time-consuming.
At that point I realized that I had never had one of these currupted
dbs myself, being compulsive about backups, and that as it seemed Peter
Miller already had the knowledge I was seeking, I could sleep soundly
at night knowing I could pay his company what seems to me to be a
ridiculously low fee to recover any corrupted mdb I might have.
As you seem to have a magic touch for recovering mdbs perhaps you could
start a recovery business at say 75% of Peter's prices. I dare say if
you were willing to post a performance bond of $500 USD as well you
would get quite a lot of business.
Terrell Miller <mi******@bellsouth.net> wrote: Some may do such. Others get much more detailed and have written their own code to examine the structure of MDBs.
I'm sure they do, but what's the point?
When I was a consultant the senior guy on our team came to me one day. One of his clients had a corrupt .mdb, he'd been going over it for the last hour, and he wanted my advice on whether we could reset a registry entry or recopy a dll or such.
When I told him just to open a blank database, import all the objects from the corrupt file, delete the corrupt one and rename the new database, he got *pissed*. Consultants don't do things like that, they look for excuses to waste several (billable) hours coming up with some overcomplex solution that makes them look clever.
So he diddled around with the broken .mdb for a long time, then finally gave up and turned it over to me. It took me all of four minutes to do precisely what I had suggested in the first place.
Meanwhile the client is sitting there with this "are you guys through *now*?" glare on his face.
<shrug> So that's one data point on the graph. Doesn't count for much.
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 ly******@yahoo.ca wrote: I have seen several, perhaps 20, corrupted mdb files. I have restored some. In none of the cases, did a simple import of all the objects into a new db effect a complete recovery. In almost all these cases the db has lost contact with a table; the pointers to the table are gibberish, or point to gibberish. In this situation one cannot import the table to another db.
That's why I always push for at least a file-server solution instead of
a single database, actually. Back-ends on a server that's backed up
daily are a lot less corruptible, and a lot easier to recover than
native tables IME.
As you seem to have a magic touch for recovering mdbs perhaps you could start a recovery business at say 75% of Peter's prices. I dare say if you were willing to post a performance bond of $500 USD as well you would get quite a lot of business.
nah, I like app development too much to turn into a utility guy. There
are a lot of people who make good livings writing utilities and classes
and such, more power to them as long as they are actually adding value.
--
Terrell Miller mi******@bellsouth.net
"Every gardener knows nature's random cruelty"
-Paul Simon RE: George Harrison This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Cliff Wells |
last post by:
Hi,
I'm writing an application that needs to know if an Internet connection
is available. Basically, I want to have something similar to what a lot
of email clients have, where the app can work...
|
by: mark4asp |
last post by:
Hello,
Is there a simple way to check whether a database driver is available
on a remote server? I only have ftp access so I can only run ASP
scripts.
An ASP application on a host has...
|
by: Medved |
last post by:
Hi,
We have not a smallest access database (30 tables, 160 queries,35
forms,40 reports,15 pages) with some links to other databases and some
sql queries from other databases.The databse is not...
|
by: Orion |
last post by:
Hey,
I was wondering if it was possible to determine if you hit 'EOF' using
fseek? I'm using fseek to traverse through the file from start to end
and capturing the data into a linked list...
|
by: Wes |
last post by:
On a nightly basis, we shut the database down and do a file system backup.
A short chronology of our database problem:
8/21 - count(*) of user tables succeeded (done once a week to get...
|
by: shineofleo |
last post by:
Here is the situation: I wrote a VB programm, which stores all the
information in a single Access database file using jet engine. It
worked well, however one of my customs reported that there was...
|
by: NEWSGROUPS |
last post by:
Is there any way to find out what database object or table was corrupt after
a repair has run in Access 2000? If I can find this out I may find out why
the corruption is happening.
Any help would...
|
by: Nathan Sokalski |
last post by:
When determining whether a String can be converted to a DateTime, you can
use the IsDate() method. However, I would also like to know whether the
string is a date, a time, or both a date and a...
|
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: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM).
In this month's session, the creator of the excellent VBE...
|
by: MeoLessi9 |
last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
|
by: Aftab Ahmad |
last post by:
Hello Experts!
I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
| |