Francisco H Tapia
my.lists at verizon.net
Mon Feb 23 13:12:36 CST 2004
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 >>> >>>