I have been searching high and low for answers to basic questions about String Theory, but I thought I'd lower myself to VB and Access.

So far I've figured out how to delete tables from the database, how to compact it from VB and how to otherwise manipulate records in tables. But...

What I need to do is test for the existence of a specific table in an Access database before trying to delete it. If the table is there, it deletes. If not, it abends (old COBOL word...) and tells me that the item is not found in the collection.

Along a similar vein, can I use wildcards to delete everything at once regardless of the name(s)? That way I wouldn't have to look for a specific table...

<sigh> I really do miss Delphi...