deleteting a table in SQL server

  • Thread starter Thread starter thriveni
  • Start date Start date
T

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting table in SQL server 1
Creating a querydef of a stored proc on Sql Server 8
Modify Linked SQL table in Acess via VBA code 7
DSN Less Connection 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
DoCmd.TransferDatabase acExport to SQL server 2005 2
Index with SQL Server Linked Tables 1
How to change the DSN settings. 1

Back
Top