Check to see if table Exists 1

[DseeDm]

Hello,

I'm using Access97 and wondering whats the quickest way to determine if a table exists. I want to delete the table if it exists. Currently, I loop through Tabledefs and I delete the table if found. The more tables I have, the longer this takes...

Any Ideas?

Thanks
DCD

 

[PHV]

And what about something like this ?
On Error Resume Next
DoCmd.RunSQL "DROP TABLE [" & strTableName & "];"
On Error GoTo yourErrorHandler

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244