Access: Query to change/update a linked table

Posted on 2006-05-17
Last Modified: 2012-06-21
I am working with Access 2003 and Sharepoint Services.  I have created a Sharepoint "List" and it has the same field names as an Access table.  I made a query to update or append (I don't know which is proper) to take the data from the Access table and "uplink" or change the linked sharepoint table.

I don't know enough about how I can change the data in a linked table.  Any ideas?  This might seem like a snake eating its tail but the original data is coming from other tables elsewhere.  The final destination is in Sharepoint.

Question by:cepes
    LVL 77

    Expert Comment

    Hi cepes,

    A linked table in Access, which is based on a sharepoint list, is just like any other table in Access.

    You just edit it as normal in a form or a datasheet.


    Author Comment

    Hi Pete:
    I understand the premise that any table can be updated but what query do I run to change the data in the Sharepoint linked table (list)?  And when I tried to run an update query, the link goes away.

    LVL 77

    Accepted Solution

    Are you using File>GetExternalData >Link Tables to link to the sharepoint list?


    Author Comment

    I'm getting back to you late but I figured out how to uplink to Sharepoint OR in essence, keep the link up and going.  

    The queries I was looking for were the DELETE query and the APPEND query.  The delete query deletes all the data in the sharepoint linked table (list) and the append query plugs in new data... all without breaking the link.  In sum, I have data coming from database A (in dbase IV), I crunch and query it into an Access database, then I "uplink" it to a linked Sharepoint List.  This way, Sharepoint becomes the "reporting mechanism" or the "dashboard" for database A.

    Thanks to all.


    Expert Comment

    Hi Cepes, I essentially am doing the same thing you are doing in terms of having a DELETE and an APPEND query to update the data in a SharePoint linked table (list), but as far as you "uplinking" it, could you clarify this a bit more?



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now