Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Appending to Linked Table (Access 97)

    Transcripts.mdb contains table CompletedCourses. Marks.mdb links to this table. Info from a query in Marks is to be appended to the table in Transcripts. Should the "destination database" property of the query be 'Current,' or should it contain the filepath to Transcripts? This previously worked using the latter method, but since then, both databases have been moved to a different location. The linked tables work properly, but the append query gives a message: cannot find file I: Academic etc , even though the file path and name shown are correct.
    Thanks, Betty

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Appending to Linked Table (Access 97)

    if this is going over a network i would use universal pathing
    server name folder name filename
    instead of a drive letter
    especially if more than one computer is going to use the database

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

    Re: Appending to Linked Table (Access 97)

    I can't figure out what you're tyring to do. You have a Transcripts database and a Marks database. CompletedCourses is a table in Transcripts and Marks has a link to that table. You want to run an append query in Marks to add data to the CompletedCourses table. Is that right so far?

    If it is, then you don't have to worry about the destination database. You are appending to the linked copy of CompletedCourses, which automatically adds the records even though you have told it to use the current database. The current database is where your active link to CompletedCourses lives, so that's where your query needs to run. You're making unnecessary work for yourself appending directly to the source database..
    Charlotte

  4. #4
    New Lounger
    Join Date
    Mar 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Appending to Linked Table (Access 97)

    Thanks so much. This is so obvious in retrospect. This was my first db with linked tables, and I have no idea why I set it up with a Destination db in the first place. It works perfectly now.
    /Betty

Posting Permissions

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