+ Reply to Thread
Results 1 to 2 of 2

Code List Tables - missing the Linked Tables

  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    Vail, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    83

    Exclamation Code List Tables - missing the Linked Tables

    This code will list all of the "local" Access Tables (minus the system tables and some 3rd party tool tables that start with the letter 'U'
    The code creates a table and populates it.
    I might add code for Excel reports later.

    PROBLEM - this code is skipping a couple of hundred SQL Server Linked tables.


    so close! ( I hope)

    Please Login or Register  to view this content.
    Last edited by RxMiller; 12-10-2009 at 01:16 PM. Reason: Solved

  2. #2
    Registered User
    Join Date
    03-05-2009
    Location
    Vail, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    83

    Talking Re: Code List Tables - missing the Linked Tables SOLVED


    Gee.. thanks for the help ( I say talking to myself).
    Possibly the MS TechNet is wrong on the Table Type code. Found this by trial and error (see Case statement).
    This code documents my Access Database with dozens of local tables and hundreds of SQL Server Linked tables. Shows each field and provides information on the field type.
    It creates a Table in Access with this information.
    The Excel side of this forum should provide information on how to use it in an Excel report.


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1