How to drop tables using SQL ? I use ADODB connection for microsoft access. My tables name is "Newtables" I want delete this tables if this tables exist in the database.
Printable View
How to drop tables using SQL ? I use ADODB connection for microsoft access. My tables name is "Newtables" I want delete this tables if this tables exist in the database.
Could you please not double post?
I've already answered you here
http://www.vbforums.com/showthread.php?t=525012
I just noticed that you're using MS Access. This kind of information is useful to give out when asking a question. Please remember that there are no psychic programmers.
In MS Access, to drop a table if it exists, you'd probably want to call the DROP TABLE statement directly and handle an error. An error would mean that it didn't exist but if it does exist, it'll get dropped.