VB access to tables collection

B

Bruce Beitman

How do I programmatically view the tables collection to
determine the fields in the table? I have been able to
view the tables collection using the AccessObject and the
alltables. What happened to the documentation?
 
M

Marshall Barton

Bruce said:
How do I programmatically view the tables collection to
determine the fields in the table? I have been able to
view the tables collection using the AccessObject and the
alltables. What happened to the documentation?
Click to expand...

It sounds like you're using Jet tables with ADO in a VB
program, if so, I have no idea.

If you're using VBA in Access with Jet tables, then you
should be using DAO. In this case, Use the TableDefs
collection to "view" the tables and then use a TableDef's
Fields collection to "view" the fields in the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding Built-in Access tables 4
enumerating tables collection or fields in ADOX blows up Access 4
AllTables VS TableDefs 2
refer to an access tables properties 1
Table Collection 9
How do you get linked table property using VBA 1
combo box with table list 2
Code to Search Tables Collection for a Specific String 3

Top