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