Results 1 to 5 of 5
  1. #1
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398

    Table Properties for linked tables

    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?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    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.

  3. #3
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398
    Within the list of table obects, right click on any table, and select "Table Properties" Nothing is shown in the description field

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    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.

  5. #5
    crowegreg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Posts
    398
    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!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 04-05-2013, 12:49 PM
  2. Replies: 6
    Last Post: 05-16-2012, 12:43 PM
  3. Replies: 5
    Last Post: 02-02-2012, 06:42 PM
  4. Replies: 3
    Last Post: 01-03-2012, 12:28 PM
  5. Replies: 7
    Last Post: 08-18-2011, 02:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums