Thanks, Peter. I knew there was something like that.
But, for future reference, can you tell me why
Application.RefreshDatabaseWindow
DoEvents
isn't sufficient? Would it have worked if I'd invoked a dummy query on the
view before I tested for its existence?
-- Allen
> Use
> SELECT * FROM INFORMATION_SCHEMA.VIEWS
[quoted text clipped - 30 lines]
> > I'm now having to resort to error-trapping, which seems heavy-handed to
> > me.
Pieter Wijnen - 05 Oct 2007 18:24 GMT
Don't work with ADP's myself.
however: The Beuty of the Information_Schema views are that they are
cross-platform
MSSQL, Oracle MySQL, ...
A shame they don't cover indexes though
Pieter
> Thanks, Peter. I knew there was something like that.
>
[quoted text clipped - 44 lines]
>> > I'm now having to resort to error-trapping, which seems heavy-handed to
>> > me.