Opposit of a maketable query

[John Baker]

Hi:

Can someone tell me how I remove a table from the system. I know there is a make-table
query, that will create a table based on the query. However i cant find a way to REMOVE a
table programmatically.

Thanks

John Baker

[Frank]

Don't know if you consider this programmatically, but you could use the
delete object command in a macro.
"John Baker" <Ba******@Verizon.net> wrote in message
news:tj********************************@4ax.com...

Hi:

Can someone tell me how I remove a table from the system. I know there is a make-table query, that will create a table based on the query. However i cant find a way to REMOVE a table programmatically.

Thanks

John Baker

[Wayne Gillespie]

On Thu, 17 Jun 2004 00:00:09 GMT, John Baker <Ba******@Verizon.net> wrote:

Hi:

Can someone tell me how I remove a table from the system. I know there is a make-table
query, that will create a table based on the query. However i cant find a way to REMOVE a
table programmatically.

Thanks

John Baker

CurrentDb().TableDefs("NameOfTable").Delete
Wayne Gillespie
Gosford NSW Australia

[John Winterbottom]

"John Baker" <Ba******@Verizon.net> wrote in message
news:tj********************************@4ax.com...

Hi:

Can someone tell me how I remove a table from the system. I know there is a make-table query, that will create a table based on the query. However i cant find a way to REMOVE a table programmatically.

drop table <table name>