>Hi, all
>Anybody know the way to make a class or function to validate a database and repair it if isn't valid ???
>
>I know that the Validate Database Recover is only for the command windows and we can't able to do it programmaticaly. Another way ????
>
>Thanks for your time
You could probable write it yourself with a combination of the following methods:
open the dbc as a table, and scan through it.
for every
field: test its existence in its table or view
table: make sure it exists and that it belongs to the database
index: make sure its expression is valid and that the table knows about it
relations: well, your on your own here.
I have never done this before, but it should be fairly straightforward. For records in the dbc that fail the test, delete them, or do what you see fit.
Erik Moore
Clientelligence