Within the FE DB, viewing the table properties for my linked tables to a BE DB, the descriptions are not their. Can anything be done to have them viewed?
Within the FE DB, viewing the table properties for my linked tables to a BE DB, the descriptions are not their. Can anything be done to have them viewed?
How are you viewing the properties - open the link in design view? The Description should show, does for me.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Within the list of table obects, right click on any table, and select "Table Properties" Nothing is shown in the description field
I did a test by entering some text in the Description property for the table in the backend. Then I viewed the link in design view and the Description property has the link path, not what I typed into the backend. But it is what I see when I hover over the link.
Apparently that Description box is only for actual tables, not links or queries.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
OK. At least I know it's not me.
I had previously written code to output all table info: table name, table description, and the names of all the fields with their data type into an Excel spreadsheet. The spreadsheet still shows the table description.
Thanks for looking into this question!!