Re: Corrupted table in VFP9
- From: Jim Frye <Jim Frye@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 13 Jan 2007 13:48:01 -0800
Was this table created in an earlier version of VFP, say 6.0 or 7.0 ? if so
you may want to use the 'Set tablevalidate to 0' in the main prg file. I know
this to be a problem with 8.0 and specifically to tables included in DBC's
created in earlier Pre 8.0 versions of vfp.
"Dan Tallent" wrote:
Data corruption in Foxpro is usually caused by a machine turning off.
suddenly (power failure).
Make sure any PCs running your application are plugged into a battery
backup.
It could also be a problem with a Hub/Switch loosing power. You should also
have these plugged into a battery backup as well.
If your problem is network related, you should be able to determine this by
copying a large (300 megs or bigger) across the network. I suggest using a
Zip file for this test. This way you can run the CRC test on the file once
it has been copied. Do this test a few times in a row. If the CRC test ok
after a few test it is most likely not a wire or network card.
Hope this helps
Dan
"Fred Taylor" <ftaylor@xxxxxxxx!REMOVE> wrote in message
news:O0QZuNZCHHA.204@xxxxxxxxxxxxxxxxxxxxxxx
Sounds more like a piece of flakey hardware. Maybe a switch is going bad,
or a cable that has a bad connection. This truly sounds more like a
hardware issue.
--
Fred
Microsoft Visual FoxPro MVP
"Sandor Hajdu" <SandorHajdu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8AA8FDAD-8D2D-46AD-8BB6-CDFF8A94F3B6@xxxxxxxxxxxxxxxx
I think my program is OK, because sometime we have this problem every day,
sometime we do not have for weeks.
I try to stop the Virus checker. I hope that will help.
Thank you again Bob.
--
Sandor
"Bob" wrote:
Sandor,
Try stopping any Virus checker from going into the data folder.
From my experience, this appears to prevent the problem arising in the
first
place.
Be sure your VFP code is correct and complete.
--
Regards
Bob B.
"Sandor Hajdu" wrote:
Thank you BOB.
But we have this error ten times per day. It means every time I have
to run
your program. I think this is not the best solution.
--
Sandor
"Bob" wrote:
Sandor,
Take a look at he blog
http://rcl-systems.blogspot.com/
It contains an article on 2091 corrupt header records and how to fix
them.
Regards
Bob B.
"Sandor Hajdu" wrote:
How can I find out what the problem is?
--
Sandor
"Josh Assing" wrote:
Most likely network issues.
On Wed, 15 Nov 2006 23:39:01 -0800, Sandor Hajdu
<SandorHajdu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Very often, but not every time we have the following error
message when we
want to insert a new record in a table: "Table xxx.dbf has
become corrupted.
The table will need to to be repaired before using again."
/Error 2091/
Is it a program error or network one?
Can anyove help me?
Meny thanks in advance.
--- AntiSpam/harvest ---
Remove X's to send email to me.
- Prev by Date: Re: Strange problem 4
- Next by Date: Re: which port use VfP9
- Previous by thread: Generic XML reader
- Next by thread: Into Table or Into Cursor
- Index(es):
Relevant Pages
|
