I need to delete multiple tables from an access 2000 database using vbscript.
I have an issue with the database and it appears that it could be hundreds of temporary tables in the form of
Ztemp balance 20-2-2014, Ztemp balance 21-2-2014, etc and I want to get rid of the lot.
so I need a sql do delete en masse
delete TABLE where tablename LIKE "Ztemp" or what ever the correct nomenclature is
thanks in advance