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.