var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Vb Code To Delete A Table?
I have a table that needs to be deleted in 6 months time, I currently manually do this but can it be automated if I enter the date which it needs to be deleted??
How do you want to delete it? ADO? DAO?
Originally Posted by Davekingwcp
SQLString="DROP TABLE SmoeTable;"
In addition to M Owen's suggestion you can say
If DeletionDate >= date()+ 6*30
Docmd.RunSQL("Drop Table yourTableName;")
Where DeletionDateis the date, when you want to delete your Table