[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

Access: Query to change/update a linked table

Hi:
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.

Charlie
0
cepes
Asked:
cepes
  • 2
  • 2
1 Solution
 
peter57rCommented:
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.


Pete
0
 
cepesAuthor Commented:
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.

Charlie
0
 
peter57rCommented:
Are you using File>GetExternalData >Link Tables to link to the sharepoint list?

Pete
0
 
cepesAuthor Commented:
Hi,
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.

Charlie
0
 
fatalblitzCommented:
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?

Thanks

Kevin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now