![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/A> \nHey, AK. Of course you can delete a table from a Jet database using a script; after all, you can do anything<\/I> using a script!<\/P>\n
Well, OK, maybe not DHCP server stuff. And maybe you can\u2019t change the display resolution of your computer. And maybe not – well, let\u2019s just say that when it comes to databases<\/I> you can do pretty much anything using a script. Including deleting a table.<\/P>\n
Let\u2019s take a look at a script that opens a hypothetical database named Inventory.mdb and then deletes a table named HardwareBackup:<\/P>
Set objCatalog = CreateObject(“ADOX.Catalog”)\nSet objConnection = CreateObject(“ADODB.Connection”)<\/p>\nobjConnection.Open _\n “Provider= Microsoft.Jet.OLEDB.4.0; ” & _\n “Data Source=inventory.mdb” <\/p>\n
Set objCatalog.ActiveConnection = objConnection\nobjCatalog.Tables.Delete “HardwareBackup”<\/p>\n
objConnection.Close\n<\/PRE>\n
You\u2019re right: there isn\u2019t<\/I> much to it. We begin by creating a pair of object references. The first – objCatalog – represents an instance of the ADOX Catalog<\/B> object. (ADOX stands for ActiveX Data Objects Extensions for Data Definition Language and Security – trying saying that<\/I> three times fast. Or try saying it once without taking a breath.) <\/P>\n
ADOX, by the way, is an extension to ActiveX Data Objects (ADO) that enables you to do things like, well, delete tables.<\/P>\n
The second object reference – objConnection – represents an instance of the ADO Connection<\/B> object; we\u2019ll use this object to open the database Inventory.mdb. That\u2019s what we do here:<\/P>objConnection.Open _\n “Provider= Microsoft.Jet.OLEDB.4.0; ” & _\n “Data Source=inventory.mdb”\n<\/PRE>\nNote that because Inventory.mdb is located in the same folder as our script we didn\u2019t have to specify the entire path.<\/P>\n
After we make the connection we assign the objConnection reference to the ActiveConnection<\/B> property of our Catalog<\/B> object; this lets the Catalog<\/B> object know which database to work with. We then use the Delete<\/B> method of the Tables<\/B> collection to delete the table named HardwareBackup:<\/P>objCatalog.Tables.Delete “HardwareBackup”\n<\/PRE>\nThat\u2019s all there is to it. We close the connection and go home, another job well done.<\/P>\n
Disclaimer<\/B>. Ok, so maybe your boss won\u2019t<\/I> let you go home after you run this script. But it never hurts to ask, right?<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! Can I delete a table from a Jet database using a script?— AK Hey, AK. Of course you can delete a table from a Jet database using a script; after all, you can do anything using a script! Well, OK, maybe not DHCP server stuff. And maybe you can\u2019t change the display […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[19,146,3,5],"class_list":["post-70253","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-activex-data-objects-ado","tag-databases","tag-scripting-guy","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! Can I delete a table from a Jet database using a script?— AK Hey, AK. Of course you can delete a table from a Jet database using a script; after all, you can do anything using a script! Well, OK, maybe not DHCP server stuff. And maybe you can\u2019t change the display […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/70253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=70253"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/70253\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=70253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=70253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=70253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
\n![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")