[AccessD] A2K:ADO Version of the following

Francisco H Tapia my.lists at verizon.net
Mon Feb 23 13:12:36 CST 2004


That would delete the table :S

-- 
-Francisco


Gustav Brock wrote:

>Hi Darren
>
>Can't you use a pass-through query and SQL:
>
>    DROP TABLE ...
>
>/gustav
>
>
>  
>
>>Bugger
>>    
>>
>
>  
>
>>>Unfortunately all that stuff is DAO specific.  There is no (AFAIAA) any
>>>equivalent in ADO.
>>>      
>>>
>
>---
>
>  
>
>>>I have a nice bit of code (Thanks Deano) that drops all the linked tables in
>>>a dB - cool
>>>Does anyone know the ADO version of the code below?
>>>
>>>Many thanks
>>>
>>>Darren
>>>
>>>""""""""""""""""""""""""""""""""""""""""""""""
>>> Dim lnk As DAO.tabledef
>>>
>>>    For Each lnk In CurrentDb.TableDefs
>>>        If lnk.Attributes = dbAttachedTable Then
>>>            CurrentDb.TableDefs.Delete lnk.Name
>>>        End If
>>>    Next
>>>      
>>>





More information about the AccessD mailing list