When I use the execute method to run a make-table query, it errors if the table already exists. I want the query to overwrite the table if it exists. Is there a way to do this without having to delete the table with code?
Matt(+)
Printable View
When I use the execute method to run a make-table query, it errors if the table already exists. I want the query to overwrite the table if it exists. Is there a way to do this without having to delete the table with code?
Matt(+)
Nope you have to drop the table if it already exists. you can do that in your execute command though.
I don't know about from code, but in Native Access, you can turn
the warnings off. Then it doesn't ask the stupid "Do wish to
overwrite".....Perhaps if you turned the warnings off thru code,
this would work?
HTH
What DB are you using?
I used a DROP TABLE query and it worked. Thanks