Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread MB Software Solutions
James E. Harvey wrote: The table was fine 10 minutes ago. I ran several reports against it, no problems??? It's my audit table and now users can't open forms. I don't have foxfix, but do have last nights backup, but was wondering why this happened??? Is there less expensive option than

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread James E. Harvey
Of MB Software Solutions Sent: Wednesday, November 22, 2006 9:24 AM To: profox@leafe.com Subject: Re: Error 2091 table corrupted, needs repaired! James E. Harvey wrote: The table was fine 10 minutes ago. I ran several reports against it, no problems??? It's my audit table and now users can't

Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread MB Software Solutions
James E. Harvey wrote: I had an old backup locally which I just copied overtop and the file opens now. There is NO REASON as far as I can tell why this happened, no loss of power, and no one admits to shutting down badly, etc., etc. It really concerns me as the system has been stable for

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Tracy Pearson
Looking up the error, it might be a reccount problem. Check this UDF: http://fox.wikis.com/wc.dll?Wiki~UDFFixRecCount Tracy ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of

Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Malcolm Greene
James, I use a text file for my audit data ... because of cases just like you (and Michael) described. Malcolm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread MB Software Solutions
Malcolm Greene wrote: James, I use a text file for my audit data ... because of cases just like you (and Michael) described. Cooldo you just do a STRTOFILE() and use the APPEND clause/option? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Rick Schummer
James, Is there less expensive option than foxfix 5.2 ($249.00) Recover from Abri.com is under US$100 and has only failed me once in the years I have used it. I have only had to fix tables a handful of times to date, and the only time it failed me was when I recommended it to another developer

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread James E. Harvey
PROTECTED] 717-637-8931 fax: 717-637-6766 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: Wednesday, November 22, 2006 10:30 AM To: profox@leafe.com Subject: RE: Error 2091 table corrupted, needs repaired! Looking up the error, it might

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Sietse Wijnker
. www.hanoverpa.com [EMAIL PROTECTED] 717-637-8931 fax: 717-637-6766 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: Wednesday, November 22, 2006 10:30 AM To: profox@leafe.com Subject: RE: Error 2091 table corrupted, needs

Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread MB Software Solutions
James E. Harvey wrote: That's interesting. So if it happens again I'll try the copy command first. It is bothersome that it occurred in the first place though. If it happens again I'll really be concerned... Jim -- saw this on a Google Ad just now:

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Peter Hart
] On Behalf Of James E. Harvey Sent: 22 November 2006 16:16 To: 'ProFox Email List' Subject: RE: Error 2091 table corrupted, needs repaired! That's interesting. So if it happens again I'll try the copy command first. It is bothersome that it occurred in the first place though. If it happens again I'll

Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Seng Hock Yap
hi, try set tablevalidate to 0 USE badtable.dbf COPY TO temp WITH cdx use COPY file temp.* to badtable.* On 11/22/06, James E. Harvey [EMAIL PROTECTED] wrote: The table was fine 10 minutes ago. I ran several reports against it, no problems??? It's my audit table and now

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread James E. Harvey
Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Hart Sent: Wednesday, November 22, 2006 11:25 AM To: ProFox Email List Subject: RE: Error 2091 table corrupted, needs repaired! Hi John Do you want a copy of my dbfrepairer. Its not finished yet but as would have probably

Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Malcolm Greene
Michael, I use a text file for my audit data ... Cooldo you just do a STRTOFILE() and use the APPEND clause/option? If I'm just logging activity vs. tracking data changes that could work. If I'm tracking data changes where memo fields are involved then I preprocess the saved data with

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Peter Hart
To: 'ProFox Email List' Subject: RE: Error 2091 table corrupted, needs repaired! Hello Peter, I'm Jim Harvey, John Harvey is the real VFP expert, I'm just a wanna b :), but I would be pleased to review dbfrepairer. Jim James E. Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc

Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread MB Software Solutions
Malcolm Greene wrote: Cooldo you just do a STRTOFILE() and use the APPEND clause/option? If I'm just logging activity vs. tracking data changes that could work. If I'm tracking data changes where memo fields are involved then I preprocess the saved data with special delimiters ('|'

RE: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Virgil Bierschwale
://www.bierschwalesolutions.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James E. Harvey Sent: Wednesday, November 22, 2006 8:33 AM To: 'ProFox Email List' Subject: RE: Error 2091 table corrupted, needs repaired! I had an old backup locally which I just copied overtop

Re: Error 2091 table corrupted, needs repaired!

2006-11-22 Thread Gérard Lochon
There is a .vcx missing. Gérard. - Message d'origine - De : Peter Hart [EMAIL PROTECTED] À : ProFox Email List profox@leafe.com Envoyé : mercredi 22 novembre 2006 17:53 Objet : RE: Error 2091 table corrupted, needs repaired! Sorry about that Jim Here is a link to the pjx file