March 28, 2005 at 8:24 am
I have code written from before when my tables were stored in access and I used the table descritpion property to populate a combo box but since I changed to a SQL backend I am not getting the table descritpions to be passed in to access when the tables are linked is there a way to do this.
March 28, 2005 at 10:07 am
To my knowledge the table description is resident in Access ONLY. You can add columnar descriptions in SQL but not table (that I know).
I would assume you will need to create another table that has tablename and description and use this to populate your drop-down...
Good Hunting!
AJ Ahrens
webmaster@kritter.net
March 28, 2005 at 10:13 am
In the SQL table properties their is a property of the fields in the table that has the description. I just need to get this information back to my access frontend.
March 28, 2005 at 4:49 pm
You are correct there is a system table that stores descriptions of FIELDS but not a TABLE descriptor. These are extended table properties and you can look them up in BOL
Good Hunting!
AJ Ahrens
webmaster@kritter.net
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply