Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt Table
Message
From
09/07/2003 07:22:17
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00808306
Message ID:
00808399
Views:
18
Dennis,

I ASSUME that you're using VFP8.

If so, have a look at the SET TABLEVALIDATE command of VFP8. Also, a search on "TABLEVALIDATE" hee should give you a few ideas to work with.

But I'm also interested in the circumstances that produced this error. I would appreciate it if you would answer the following and provide any other information that you may feel is relevant:

1) Are TRANSACTIONs involved?

2) Did it occur on an INSERT or APPEND or on some other command?

3) What OS/SP was the app. running under when it happened?

4) What OS/SP is the file server running?

5) have users ever complained in the past of lost or missing information?

6) What version of VFP did you migrate the application from?

good luck

>Hi,
>
>I've gotten the following message about a table becoming corrupt. Foxpro help says to use a 3rd party tool to repair the table. Any suggestions?
>
>Table ‘x:\data\visitors.dbf’ has become corrupted. The table will need to be repaired before using again.
>
>Error: 2091
>
>Table ‘x:\data\visitors.dbf’ has become corrupted. The table will need to be repaired before using again.
>
>Thanks,
>
>Dennis
Previous
Reply
Map
View

Click here to load this message in the networking platform