Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link tables - to a db with non mdb file extension (2000/XP)

    We use some software that stores it's data in an access database.

    The software uses the file extension .gpj instead of .mdb.

    How can I link to the tables in this database - a colleague managed to do it but can't remember how.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link tables - to a db with non mdb file extension (2000/XP)

    Activate the Visual Basic Editor (Alt+F11).
    Activate the Immediate window (Ctrl+G)
    Type the following, substituting the correct path and names:

    DoCmd.TransferDatabase acLink, "Microsoft Access", "C:OtherSoftwareData.gpj", acTable, "SourceTableName", "LinkedTableName"

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Manchester, Gtr Manchester, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link tables - to a db with non mdb file extension (2000/XP)

    Very interesting <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    Thanks

Posting Permissions

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