Check if a temp table exists and drop the table

[Nebil]

I was going to check if a temp table exists and delete the it,since "the temptable already exists" arises if you want to perform another operation.
Here's the code i used five statements but it says syntax error in drop table or drop index statement.
Any help would be appreciated.

"DROP TABLE IF EXISTS LIKE 'prtempTable%'"
"DROP TABLE IF EXISTS LIKE '%prtempTable%'"
"DROP TABLE IF EXISTS WHERE TABLE LIKE 'prtempTable%'"
"DROP TABLE LIKE 'prtempTable%'"
"DROP TABLE LIKE '%prtempTable%'"

[Reverend Jim]

Try

IF OBJECT_ID('myTable','U') IS NOT NULL DROP TABLE myTable

[Nebil]

Does this work on access database?

[Reverend Jim]

I've never tried it on an Access database. I suggest you create a dummy table and try it out.

[Nebil]

It doesn't work,since it's for sql server db.Is there another way to solve it?

[Reverend Jim]

How about just putting the delete code in a Try-Catch block and seeing what error occurs if the table does not exist? That will tell you what error to ignore.

[Nebil]

I used this sub procedure and it worked fine.

On Error GoTo ErrorHandler
        Dim str As String
        str = "DROP TABLE ptempTable"
        ExecSQL(str)
        Exit Sub
ErrorHandler:
        If Err.Number = 7874 Then
            Resume Next
        End If

Thanks by the way