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