Delete Tables - Nifty Access
A recent question on Access World Forums prompted me to create this method of deleting tables in an MS Access database.
More Info on the Nifty Access Website:- https://www.niftyaccess.com/delete-tables/
The function "fCreateTable" (VBA code) creates a new table with two Fields, one field to store the name of the tables present in the database and the other field to allow the user to select whether they want a particular table deleted or not.
Then the next major function "fFillTableFieldData" (VBA code) reads through the list of selected tables and deletes them from the MS Access database.
Everything is controlled by a couple of command buttons, and there is a helper routine, code that you would normally put in a separate module and use from various places throughout your database. For the purposes of this example, it's best contained within the form.
ALL the information you need to create this MS Access Component for yourself is contained within this YouTube Video:-
Delete Tables - Nifty Access https://youtu.be/PQ6DrxiTjdc
This is a self-contained unit that you can drop straight into any MS Access database and delete any tables you select from the list. ALWAYS backup your database before making any alterations!