Field Captions in Access

[jalexm]

I'm using VB6 and Access. I need to get a list of field names and respective field captions for each table. I need to use this information in my app.
I have tried ADO/ADOX commands but this is not possible, since field Caption property is not available to ADO/ADOX. I'm thinking about creating an auxiliar table inside database with fields like TableName, FieldName, FieldCaption.

But I have no idea about how to save that information to the auxiliar table. I don't know if this is made inside the app. with some SQL commands or by internal Access commands.

Also, this need to be performed everytime the app. opens the database, so that the information is always updated.
Please, any idea?
Thanks.

[Ritual]

In sql you can use 'show tables' to get a list of the tables in your database.

With the list of tables you can make a command like
"show columns from -your table-"

[jalexm]

In sql you can use 'show tables' to get a list of the tables in your database.

With the list of tables you can make a command like
"show columns from -your table-"

I get an error when I try these commands.
I guess they are not available in Access.
More ideas?