Gustav Brock
gustav at cactus.dk
Mon Feb 23 07:21:53 CST 2004
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