Hi there,
I’d like to have a combo box list all the table names of my Access database. I took a quick peek at the system tables but I can’t get things to work. The MSysObjects table seems not to be listing table names, but rather query names and maybe other objects. What I’d like to know is if there is a table such as one I recall there is in SQL Server where I can find all the table names.
Additionally, I’d like to have another combo box list all the field names of a certain table (which will in turn be the table selected in the first combo box). Can this be done?
As for the comboboxes code, I think it’s simple enough for me to handle. What I’d like to know is more related to WHERE these data are.
Thank you very much in advance