NOT 'A Delete Query' but 'Delete A Query'........

[soupisgood84]

.....LOL. I am trying to find some VB code to actually delete one of my tables after I'm done using it.
I use the table as sort of a buffer to get data from two tables that are very different. After I run a query and print a report based on that table, I want the DB to delete that table.

So all and all, I am just looking for some help with code that would delete a specific file from my DB.

Thanks in advance.

 

[PHV]

One way:
currentDb.Execute "DROP TABLE yourTable"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[traingamer]

Another way:

DoCmd.DeleteObject acTable, "NameofTable"

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill