DROP Table errors

is there a problem with this statement if I using an Access Database? I've used a mysql database and it seems to work fine.

SQLdrop = "DROP TABLE IF EXISTS storenames"
connList.execute(SQLdrop)

storenames is the table in the database and assume that the connection string is correct.

I get this error:


Microsoft JET Database Engine error '80040e14'

Syntax error in DROP TABLE or DROP INDEX


all help is appreciated. thanks

I don't think JetSQL know the 'if exists' addition. Try it with just
DROP TABLE tablename

you might want to try to play with this....not sure if it will work, but what the hey...

IF EXISTS( SELECT name
FROM database
WHERE name = table_name)
DROP TABLE table_name


Eric

Thanks, I thought that access couldn't handle "if exists" and I guess I was right. I will try that routine, thanks for replying.