If you using odbc to a mdb file, then you MUST have jet installed, and
THEREFORE you MUST also have dao installed on your machine (in fact, out of
the box, windows xp, server 2003, vista etc DOES HAVE the jet database
engine installed by default (thus you don't need to install anything on a
windows computer to read mdb files.
here is a windows (vbs) script that displays all tables...you can use late
binding in your project, and you should little trouble getting a list of
tables using the following idea.
Set dbeng = CreateObject("D AO.DBEngine.36" )
strMdbFile = "C:\Documen ts and Settings\Lawren ce\My
Documents\Acces s\ScriptExample \MultiSelect.md b"
Set db = dbeng.OpenDatab ase(strMdbFile)
for each table in db.tabledefs
msgbox table.name
next
The above is not a vba script. Paste the above into a text document, and
then re-name the extension as .vbs. If you double click on this file...you
see it list the tables in the given mdb file..
So there is a table collection available after you open the mdb file as per
above...
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com