By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,398 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,398 IT Pros & Developers. It's quick & easy.

Opposit of a maketable query

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
"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>
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.