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 Newsgroups: comp.lang.basic.visual.misc Subject: Re: Getting inside an .accdb file Date: Sat, 19 Nov 2011 10:29:54 -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 mzgj/lj68F+HEosAl3kyAwwFSQqfMG/2bsv18qz9rBiSuOrciG Cancel-Lock: sha1:nrjPyCjwkPSVmRQcaC77/MqiPoc= X-Newsreader: Virtual Access Open Source http://www.virtual-access.org/ Xref: x330-a1.tempe.blueboxinc.net comp.lang.basic.visual.misc:525 Tony Toews spoke: > >Yes, I know - I should have been more explicit. > >I can open a connection to the database OK, but no clue as to what > >tables and structure is in it, so I needed to query a system table to > >find out what tables are in it. > > 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. Indeed - and the original plonker who wrote the Access app (and charged a pretty penny for it, I might add) needed a good whack with a clue-stick. Basically a colletion of flat tables, absolutely no normalisation (e.g. a Customers table with a completely new record duplicating name address etc. for every additional contact at that customer) and worse, table names with spaces and table names like "11/ 09/11" -- Rob Pearson