Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    133

    Unanswered: link table using visual basic

    dummy question:

    a microsoft access book provided me a code in microsoft access module so as to connect to other mdb file's table:
    Sub Linking04()
    'link a specific table in an external database
    Dim FrontDB As DAO.Database
    Dim Lnk As DAO.TableDef

    Set FrontDB = CurrentDb
    Set Lnk = FrontDB.CreateTableDef("Customers")
    Lnk.SourceTableName = "Customers"
    Lnk.Connect = ";DATABASE=Datatables.mdb"
    FrontDB.TableDefs.Append Lnk

    End Sub

    But the external table don't appear in database window. How to make the external table to appear in database window?
    many thanks.

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Your connect statement must contain the full path of the BE-db...

    Greetz

Posting Permissions

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