[AccessD] A2K:ADO Version of the following

DWUTKA at marlow.com DWUTKA at marlow.com
Mon Feb 23 14:01:31 CST 2004


Yes, and if it's a linked table, it just deletes the link.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Francisco H
Tapia
Sent: Monday, February 23, 2004 1:13 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2K:ADO Version of the following


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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list