Results 1 to 3 of 3
  1. #1
    Adrien2 is offline Novice
    Windows 10 Office 365
    Join Date
    Nov 2020
    Posts
    1

    External source synchronisation to SharePoint list

    Good day everyone,

    I'm new to Access and would like to know if it is possible to setup an automate synchronisation reading data from SQL database to automatically update a SharePoint list.

    My scenario is the following:

    I have created in access external data connection to few SQL server tables. Then linked them as needed in Access.
    I created a query to append some columns from the results in a SharePoint list. (SharePoint Online)

    I would like to have my SharePoint list automatically updated by any changes occurring in the source SQL tables. (Read only connection, I don't want to update anything in the SQL database from SharePoint).

    I'd like a refresh rate quite close to real time, perhaps few minutes.

    I'd like to have it refreshed even when I'm off work and my computer shutoff.

    So far I'm able to manually refresh but I can't find how to automate that part

    Could someone tell if it is possible to develop such solution?

    If possible, could you please provide me with some direction?

    If not possible, could you please provide me with direction to an alternate solution?



    Thanks in advance for your support
    Have a good day
    Adrien

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    If this is a SQL server you have access to why not do it directly from SQL server and schedule a script or trigger to do the SharePoint bit from there?

    No need to involve Access, and the SQL server will be running all the time.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    In Access you could have a separate Access file with a form with a timer that calls your update query or routine, but that might interfere with you regular use of the database by the users as it would place some locks while doing it. And you will need to leave it open all the time.

    The best would be as Minty suggested to do it in the SQL server with a scheduled SQL Agent job (linking your Sharepoint as a linked server):
    https://social.msdn.microsoft.com/Fo...databaseengine
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 4
    Last Post: 02-11-2020, 03:02 AM
  2. Replies: 1
    Last Post: 01-17-2014, 03:06 PM
  3. Refresh SharePoint List - SharePoint 2010
    By jgelpi16 in forum Programming
    Replies: 0
    Last Post: 08-22-2013, 06:21 AM
  4. Synchronisation with various versions
    By asearle in forum Access
    Replies: 0
    Last Post: 03-24-2012, 02:08 AM
  5. Replies: 30
    Last Post: 06-26-2011, 10:47 PM

Tags for this Thread

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