deleteting a table in SQL server

[thriveni]

I use access2000.
I have a DSN established to SQL server. I have a table in
SQL server that is not and should be linked in access.
However I want to delete this table if it exists. How can
I do through VBA/DAO ?
any help would be appreciated.

 

[Chris Nebinger]

Do you want to delete the table in SQL Server, or just the
link?

If you want to delete it, just issue the following SQL
Statement:

Drop Table TableName


If you want to delete the link:
On Error Resume Next
DoCmd.DeleteObject acTable,"TableName"


Chris Nebinger