>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.
Eric,
Use the following:
adbobjects(ladbobjects,'VIEW')
return Ascan(ladbobjects,'V_MYVIEW') <> 0
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao