[AccessD] A2K:ADO Version of the following

John W. Colby jwcolby at colbyconsulting.com
Mon Feb 23 05:40:02 CST 2004


Unfortunately all that stuff is DAO specific.  There is no (AFAIAA) any
equivalent in ADO.

John W. Colby
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
Sent: Monday, February 23, 2004 5:40 AM
To: AccessD List
Subject: [AccessD] A2K:ADO Version of the following


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