Results 1 to 2 of 2
  1. #1
    offie is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    176

    Linked tables and refreshing

    Do the tables update automatically? I now that I can go into the linke table manager to refresh them manually but I was wondering if this happens automatically?



    I have looked around and have found sevral different sql codes that will refesh the table, but where would I put this code? Make an all powerful button?

    New at this,
    Thanks!

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    if your tables are linked to an external source they will be automatically updated with the most recent information available.

    If someone has altered or added a record in an external source but hasn't closed the record or application you can force a refreshing of data with the

    me.refresh

    command.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How about linked Tables with Sharepoint?
    By Steven.Allman in forum SharePoint
    Replies: 0
    Last Post: 04-09-2012, 06:55 AM
  2. Replies: 5
    Last Post: 02-02-2012, 06:42 PM
  3. refreshing tables?
    By danbo in forum Access
    Replies: 1
    Last Post: 12-23-2011, 03:05 AM
  4. Refreshing Linked Tables Hangs
    By blamb in forum Access
    Replies: 0
    Last Post: 12-05-2011, 12:36 PM
  5. Link Tables Not Refreshing
    By goodguy in forum Import/Export Data
    Replies: 14
    Last Post: 01-04-2011, 12:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums