Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data refresh on linked tables (Access XP)

    First, sorry if this get posted twice. I tried posting it once and it didn't appear to work.

    How often does a linked table refresh the data? I have a table that is linked to a txt file created by a Palm Pilot. It doesn't appear to refresh the data. Will I have to always use the linked table manager to refresh?

    Thanks,

    Bret

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: data refresh on linked tables (Access XP)

    You wrote:
    >>How often does a linked table refresh the data? I have a table that is linked to a txt file created by a Palm Pilot. It doesn't appear to refresh the data. Will I have to always use the linked table manager to refresh?<<

    Bret,

    What exactly do you mean by "refresh the data"? (The term "Refresh" is also used in relation to forms, and there is a difference between "Refresh" and "Requery", so I want to be sure.) What are the circumstances in which the data in the txt file is changed? That is, while the Access application is open and you are using the data?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data refresh on linked tables (Access XP)

    Maybe "update" would be a better term? We enter data into the Palm Pilot then Hot Sync that data to the PC. Once we have done the Hot Sync I want to know if the table that is linked to the txt file updates when I start the database or do I have to go to the linked table manager and update the linked table?

    We have not had the database open at the time of Hot Syncing the Palm.

    Thanks Mark,

    Bret

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

    Re: data refresh on linked tables (Access XP)

    So you're saying that you sync the Palm Pilot and the text file doesn't get updated? Or are you saying the text file gets updated but you don't see that data in the linked table? Have you, in fact, opened the text file with something like Word to be sure the file itself got updated? The link to the file doesn't hold any data at all. It merely holds the connection string that tells Access what kind of a file it is and where it's located.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data refresh on linked tables (Access XP)

    Hello Charlotte,

    I see the txt file change but I wasn't seeing the Modified Date change on the linked table. So, I looked at the data and see that it does indeed update. The modified date on the table must refer to the structure of the table being modified?

    Thanks,

    Bret

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

    Re: data refresh on linked tables (Access XP)

    The modified date for the linked table should be the last date you created or refreshed the link. It doesn't have anything to do with the contents of the linked file.
    Charlotte

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: data refresh on linked tables (Access XP)

    If the source file for that linked table is in the same directory as before, each time you use the table in Access it will give you the most recent data from the file. You shouldn't have to do anything.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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