Iīm creating a VB app. to manipulate an Access database. The database has no form and no user interface. This is done by VB app.
I need to get the field/column Captions from each table defined in database but they are not available to ADO/ADOX.
One solution is to copy them to Description property since this one is available to ADO/ADOX. The problem is how to do it. Also, it needs to be done everytime the database is opened by VB app. (other developers here may change the captions and forget to warn).
I think some VBA code will solve this, but I donīt have any idea how to do it.
Please, can you help?