>I have a couple of Tables and Views inside a DBC. I need to modify some fields in that tables and after that my views didn't open/work any more because the reference inside it are wrong. So I create a little program that opens the DBC file as a table and replace the name of the fields related to that view and also the code inside the property field of that each views.
>I compile the database and now when I open the database and run the views, works fine. But When I try to validate the DBC with "Validate Database" I get a bunch of errors. Is like the Property (Memo) Field was no recompiled.
>
>I read that COMPILE DATABASE compile only the Stored Procedures in the DBC. What about the Property Memo Field of each object?
>Is there another way or command to do it?
>
>Regards,
FWIW, I want to second Trey's recommendation of SDT. Great tool, not just for fixing views, but also for repairing tables, moving tables, etc. Also check out Erik Moore's eView for working with views.
Chris McCandless
Red Sky Software