Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Washington State
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is table linked? (A2K)

    Hi!

    Using VBA I need to determine if a particular table is a linked table or not.

    I assume I can find this information using the tabledef attributes. Not sure of the syntax.

    Any help?

    Thanks!
    Sam

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Is table linked? (A2K)

    Yes, you can check the Connect property of the tabledef. If it is an empty string, the table is local. If it is not an empty string, it will contain information on the type and path of the attached table.

    <code>Dim tdf As DAO.TableDef
    Dim dbs As DAO.Database

    Set dbs = CurrentDb()
    Set tdf = dbs.TableDefs(<tablename>)
    If tdf.Connect <> "" Then
    ...
    End If</code>
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Washington State
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is table linked? (A2K)

    Perfect. Thanks, Charlotte!!

Posting Permissions

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