var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: delete all table from "A" database
i would like to delete all table's from database "A".. but i am not sure that i sould use Query or code...
if there a Query or out then can u pl give me a EXAMPLE .
You can delete a table from a DB using the following command:
DoCmd.DeleteObject acTable, "tablename"
If you would like to delete all tables in the DB, then simply do a for next loop.
To do the loop you will need to add a reference to the ADO library, then the following code should work:
Dim tbl As TableDef
Dim db As Database
Set db = CurrentDb
For Each tbl In db.TableDefs
If Left(tbl.Name, 4) <> "MSys" Then
DoCmd.DeleteObject acTable, tbl.Name
the if statement is in there becuase the DB will not allow you to delete its protected system tables that are hidden.
This should work.
If you have any questions let me know.
mweyland at mnqio dot sdps dot org