Link to home
Start Free TrialLog in
Avatar of cepes
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
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

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
Avatar of cepes
cepes

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
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cepes

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
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