cepes
asked on
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
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
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
Thanks
Kevin
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