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 2484
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******@bellso uth.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******@bells outh.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******@bellso uth.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******@bells outh.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******@bellso uth.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 either in "online" or
"offline" mode (it keeps a cache of downloaded info, so it can work
without a connection if needed).
The basic problem is this: it downloads info (RSS feeds) from a variety
of sources. Any one (or more) of these could...
|
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 died again.
|
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 using many
advanced features and there are only about 15 simple macros.
Recently we have a problem with a need to repair database (2 -4 times
a week).
What is even more alarming is that 2 times happend that even after
repair we could not use...
|
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 structure. However, my loop
doesn't seem to work well - it totally fumbles out actually:
while ((a = fseek(fp,0,SEEK_CUR)) == 0){
// code here
}
|
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
statistics)
8/23 - A specific search on a specific value (one out of over 2 million)
caused postmaster to SEGV. I dropped the index in question and rebuilt it.
All appeared ok.
| |
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 some
problems with this programm. I checked, the log files showed that the
database was corrupted.
The customer told me that there no 'illegal' operation such as pull out
the plug, or kill the programm via task manager...
So is there any...
|
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 be appreciated.
Thanks,
Mark
|
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 time. Is there any simple way
to do this without using manual pattern matching? Thanks.
--
Nathan Sokalski
njsokalski@hotmail.com
http://www.nathansokalski.com/
|
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 AS GroupID
FROM tblBank
WHERE (((tblBank.Dt)>(!!-1) And (tblBank.Dt)<(!!+1)));
1.tblBank has a record in the Dt field which equals = 02/07/08
2. tbBankMinDate -1 = 01/07/08
3. tbBankRecDate + 1 = 03/07/08
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |