General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>We get this occasionally and sometimes the following works. I have no idea why but it may be worth a shot. In the command window we.......
>>CLOSE DATA ALL
>>SET TABLEVALIDATE TO 0
>>USE < tablename >
>>GO BOTT
>>BROWSE
>>
>>< append some blank records > &&anywhere from 3-5 records seems to work
>>< delete those records >
>>CLOSE DATA ALL
>>SET TABLEVALIDATE TO yourvalue
>>
>>This was a trick that was passed to me by the previous programmer. I have no clue why it works, but in most cases it does the job
>I've never used TableValidate for a table not belonging to a database. I know I didn't state that earlier but I was curious. Does that work for stand alone tables as well.
It works. And it´s even better thatn CmRepair. I fixed tables that Cmrepair couldn´t fix. May be I should had try
SET TABLEVALIDATE TO 0
before using CmRepair. I´ll try that next time.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only