How do you display Access tables and fields?

[SirPaladin]

I realize this might sound like a really simple question, but I've had little luck trying to solve it so far. I'm trying to create a Global Update utility for an Access database, and I want the user to be able to dynamically select their desired Access table, and then from that table, their desired field to update to whatever value they entered. How can I get the list of tables from a specified Access database, and then in turn, get a list of the fields in that table?

 

[JWhyte]

If you are using DAO use can use the TableDefs and Fields collections to list all the tables and fields.

If using ADO, then you can use the OpenSchema method of the Connection object to display the same information.

HTH John Whyte
jwhyte@skipton.co.uk