Groups > comp.lang.basic.visual.misc > #527

Re: Getting inside an .accdb file

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!nuzba.szn.dk!pnx.dk!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	R C Nesbit <spam@ukrm.net>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: Getting inside an .accdb file
Date	Sun, 20 Nov 2011 12:30:48 -0000
Organization	SpamTrap
Lines	18
Message-ID	<VA.00003687.0f43509f@ukrm.net> (permalink)
References	<VA.00003670.04d6f723@ukrm.net> <iq4bc794sehh1kir2pi384ilbm24jgcr4q@4ax.com> <VA.00003677.046046c6@ukrm.net> <s9bdc7lcikf52o1nnj6gq45bep3emoh36e@4ax.com> <clMxq.6136$NR2.3505@viwinnwfe01.internal.bigpond.com>
Mime-Version	1.0
Content-Type	text/plain; charset=iso-8859-1
Content-Transfer-Encoding	8bit
X-Trace	individual.net o3nUsI9llZoq+vFwkQ0DPQpWHCNINYLHykKopHdjcwGF1N5pFC
Cancel-Lock	sha1:N46gNH62V/Z0eeNFenMmsjmrSfk=
X-Newsreader	Virtual Access Open Source http://www.virtual-access.org/
Xref	x330-a1.tempe.blueboxinc.net comp.lang.basic.visual.misc:527

Show key headers only | View raw

Jason Keats spoke:
> > Ahh, then you want to go through the tabledefs collection using VBA
> > code.  But in your other reply I see that a viewer is sufficient for
> > your needs.
> 
> The following line is the solution to the problem:
> 
> Set rst = cnn.OpenSchema(adSchemaTables)
> 
> where cnn is your connection object, and rst is an ADODB.Recordset.

That's the puppy!  thanks.

-- 
Rob Pearson

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Find similar

Thread

Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-17 09:48 +0000
  Re: Getting inside an .accdb file H-Man <Spam@bites.fs> - 2011-11-17 14:37 -0700
    Re: Getting inside an .accdb file H-Man <Spam@bites.fs> - 2011-11-17 16:23 -0700
      Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-18 09:46 +0000
        Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-18 12:10 -0700
  Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-17 16:08 -0700
    Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-18 09:46 +0000
      Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-18 12:09 -0700
        Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-19 10:29 +0000
          Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-21 13:05 -0700
            Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-23 18:10 +0000
              Re: Getting inside an .accdb file ralph <nt_consulting64@yahoo.net> - 2011-11-23 15:10 -0600
              Re: Getting inside an .accdb file Tony Toews <ttoews@telusplanet.net> - 2011-11-24 17:12 -0700
        Re: Getting inside an .accdb file Jason Keats <jkeats@melbpcDeleteThis.org.au> - 2011-11-19 22:23 +1100
          Re: Getting inside an .accdb file R C Nesbit <spam@ukrm.net> - 2011-11-20 12:30 +0000

csiph-web