Re: Third party tool required

How does this fix data corruption? If the data is bad, the data is still bad
after it is put into a clean structure. And if anyone tries to shoot you
down in flames, it's because some of us have been around for a while and
have a better understanding of what goes wrong with tables and what it takes
to fix them. It is indeed reinventing the wheel, and it's usually
cheaper/faster/easier to take an existing tool and adapt that to your
purposes.

I speak from experience. Stonefield has turned out to be woefully inadequate
for our needs, and in the long run has caused more grief then it's worth. We
wrote our own table header repair utility because they (management) would
not cough up a couple hundred bucks or whatever Abri's most excellent
recover tool costs these days. So we spent 5 times as much to pay one of our
programmers to write something that was already inexpensively available that
doesn't fix most of the problems we have. Waste of time and money.

"Jan" <nomail@xxxxxxxxxxx> wrote in message
news:%23jk9SdVpFHA.1464@xxxxxxxxxxxxxxxxxxxxxxx
> What's so hard about writing your own database rebuild utility. Most apps
> need a mechanism to restructure databases when new features are added
> requiring columns and / or tables to be added or modified. Using the
> gendbc utility to generate the DML to recreate your database your utility
> simply:-
> - backs up the database to a new folder
> - destroys the database
> - recreates the database using the DML generated by gendbc
> - appends the data into the recreated database from the backup
>
> This fixes all headers, resolves data corruption and if you need to, you
> can even write your own derivation code for new columns or tables.
> Depending on the complexity of your app you could even implement a data
> integrity check and regenerate missing records based on the content of
> other tables.
>
> In our app we call this utilty installDB. We also have a rudimentary
> RepairDB that does header repairs for those dreaded 2091 errors caused by
> OPLOCKS in 2000/XP/2003. RepairDB uses low level file functions.
>
> Remember guys, this is the programmer exchange, we all have the ability to
> do these things. Before you all go trying to shoot me down in flames with
> that reinventing the wheel thing, remember data recovery is a core part of
> any app because basically you cannot rely on anything that uses
> electricity. If you don't take care of it very early on it just shows you
> aren't keeping the bigger picture in mind.
>
> My $.02
>
> HTH
> Jan
>
> "Rick Bean" <rgbean@xxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:%23rIyRFDpFHA.3244@xxxxxxxxxxxxxxxxxxxxxxx
>> Stonefield is only good for repairing the header of a .DBF, it's true
>> power is in updating tables with new, changed and deleted fields.
>>
>> Rick
>>
>> "Ook" <no usenet spam at zoot al dot com> wrote in message
>> news:unclUuApFHA.3244@xxxxxxxxxxxxxxxxxxxxxxx
>>> www.abri.com. Probably the best I've used.
>>>
>>> Stonefield is not a database repair tools, and it's ability to fix
>>> things are rudimentary at best. We use it in a very large app, and the
>>> general consensus is that we would scrap it if we had the time to rip it
>>> out of the app.
>>>
>>> "Nishu" <Nishu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>> news:73A18C7F-07FF-4FC4-ACA5-28F559E21D4D@xxxxxxxxxxxxxxxx
>>>>I need a third party tool to repair a corrupt dbf file.
>>>>
>>>> Thanx in advance
>>>>
>>>> Regards
>>>> Nishu
>>>
>>>
>>
>
>



.

Relevant Pages

  • Re: Existing Database - Create new or Fix existing?
    ... If you have spent lots of time developing the app, ... fix the issues you can (such as ensuring all ... I downloaded the free 'database checker' utility from ... Do I trawl through the report page by page and try to fix the issues one ...
    (microsoft.public.access.queries)
  • Re: Existing Database - Create new or Fix existing?
    ... I built the app in 1997 and have been adding to it ever since. ... Dozens of queries, forms and reports ... I'll continue to use the 'database checker' as I build and will no doubt be ... Can I fix it or should I leave it ...
    (microsoft.public.access.queries)
  • Re: Existing Database - Create new or Fix existing?
    ... that's one way to learn about how to build a database. ... data - forms, subforms, combos, list boxes, reports, and so on. ... I built the app in 1997 and have been adding to it ever since. ... Can I fix it or should I leave it ...
    (microsoft.public.access.queries)
  • Re: There is a problem with the Office database
    ... The Microsoft Database Utility app won't let use any of the options, ... use the Repair button to attempt to repair ...
    (microsoft.public.mac.office.word)
  • Re: Problem with database
    ... Get them to send you the secure mdw file that they used. ... first thing I tried to do when I got the file was to repair and compact it. ... app, which creates a new database and copies data over row at a time. ...
    (microsoft.public.access.security)