Look at ADBOBJECTS()
>Is there an easy way to determine if a view exists in an OPEN database before trying to open the view? Opening the .DBC as a table and then locating the viewname only works if the database is first closed.
>
>Thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer