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