Corrupt tables (very urgent) 1

[Guest_imported]

Hello together,

last night we had problems with power-supply and our VFP(6.0)-Fileserver crashed. Now we got the problem, that there are some corrupt tables with at least 50.000 lines less than necessary but the file-size of these tables could be correct, so i guess, that the missing data is still there but not visible anymore. If i try to export with "copy to" vfp crashes.
The last data we are able to browse is some days old. Do you have an idea, how we could repair these tables and make the missing data visible ? Reindex didn't help.

Thanx and greetings from germany

Buck

 

[Guest_imported]

Sorry, dont't use AOL. I got to quit now because of meeting (crisis-management). Anyway, thank you very much for your patience an for trying to help me out. Guess we will take the backup (which is 1 day old - definitly to old !) and try to reconstruct the misssing data till monday morning. i do not think that this is possible, but maybe the only chance. Hope i will keep me job after monday morning !

Cheers

Buck

 

[Raccoon]

Sorry I couldn't do more. Maybe now is the time to bring up to management the advantages of good backup power supplies.

Best of Luck - email me if you want any further help. I'll respond as soon as possible.

Mike

 

[Guest_imported]

Thanx again, we will keep in touch via mail.
Power-Supplies: We already use APC Symetra-Supplies but the Foxpro-Surver was not connected to them yet. For this machine we only had a standard APC-Smartups and the idiot who connected to this ups didn't install the monitoring-software, so the machine couldn't shut-down properly :-( !

See ya

Buck

 

[DannC]

back-up your dbf. and try:

myHandle=fopen('YourDbf',write_acces)
myError=fchs(myHandle,xxx) where xxx is a number that depends on your table size, it has to be a little bigger.
=fclose(myHandle)

take care id myError is #0. The file should be ! read only.

Have fun !!!