Access Drop Table If Exists. Modules VBA. Is there a way to drop a table and conditionally if it exists.
I was wanting to create a query that will determine if a table exists and if it does deletes that table. Now we will drop the stored procedure we created at the start of the article by executing the following code. SQL Server Drop Table If Exists.
Dim objCatalog As ADOXCatalog.
I would like the code to check to see if the table exists call it tbl_errors and if it does delete the table. DROP TABLE IF EXISTS dboProduct DROP TRIGGER IF EXISTS trProductInsert. Is there a way to drop a table and conditionally if it exists. I have an Access Database that I connect to with an OleDb connection.