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.

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


>-----Original Message-----
>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.
>
>.
>