>Is there any way to get rid of (what I think) is a corrupted view. I can see it in the Project Manager but it has no view icon - if I right click and select remove I get the message 'Database Invalid - please validate' and then I have to re-validate.
>
>I cannot see the view when I open the database container - I am pretty sure this is causing problems!
Chris,
Open the database exclusively (i.e. open database MyDBC exclusive). Then issue the validate database command. You may have to also include the RECOVER keyword in the command. That will most likely delete the record in the DBC associated with the view. If so, simple recreate the view.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao