Re: Third party tool required

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: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Portable Database Choice
    ... database alternatives and did find the options below from this search. ... of data from the desktop to mobile. ... The read-only app requires speedy lookup of data in a flat table ... Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Sqlserverce class not working when VB.Net application is running from network drive
    ... one app attempts to connect to a sdf file on a network share, ... possible that the database is already in use when you attempt to ...
    (microsoft.public.sqlserver.ce)
  • Re: MSVC++ app type choice, form design questions
    ... > 1) MSVC Project definition requires that for an MFC app I choose ... MFC's built-in database support is really built around the document/ ... with the full version of SQL Server, but it's still pretty usable -- ...
    (microsoft.public.vc.mfc)
Loading