Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!news-1.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: R C Nesbit Newsgroups: comp.lang.basic.visual.misc Subject: Re: Getting inside an .accdb file Date: Fri, 18 Nov 2011 09:46:37 -0000 Organization: SpamTrap Lines: 22 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Trace: individual.net ssTIIdY0PvRqv7EKnsbSnApw3N/I/4uPaOo51eacX+zE/kMP83 Cancel-Lock: sha1:X8vzVpQgcnTuJg5q0sSxS9AevO4= X-Newsreader: Virtual Access Open Source http://www.virtual-access.org/ Xref: x330-a1.tempe.blueboxinc.net comp.lang.basic.visual.misc:522 H-Man spoke: > >> Is there an equivalent TABLE_DEFS table I can query to get > >> a list of data tables in the .accdb file? > > > > http://bit.ly/tzkgyw > > Sorry, forgot which group I was in. > > Looks like Tony has a solution for you. > > Again, please accept my apologies. NP - actually it was helpfull, I was being blind to the obvious and didn't think of looking for a viewer, I wanted some way to programatically see the table names so I could cycle through the database and extract field names and records. -- Rob Pearson