Hi Don ---
=ADBOBJECTS(arrayname,"View")
This will return an array (arrayname) containing all views in the open database.
>How can you tell if a View already exists in a Database?
>
>DBGETPROP seems to offer no straight forward solution short of the old error trap scheme.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05