Access-Sharepoint Linkage Question

[keshavbirla]

Hi

I have been working on a monthly utilization table for my work. The utilization for all the employers is a sharepoint site where everyone fills out their entries. This Sharepoint is linked to an access DB in the background which sync the data recorded in sharepoint.

Now, our Sharepoint is restricted to 5000 entries overall so we have to delete the over usage manually, but the same is been deleted in Access table as well as they are synced. We have to pull up a report monthly for which we want all the records.

My question is - Is there a way that even after deleting the entries in Sharepoint manually, the table in Access DB retains the deleted values; so that for pulling up our report we have the whole data including the sharepoint deleted ones.

Please let me know for any further clarification I must provide.

Thank you in advance!



Keshav Birla

[hehrerh]

You could create an APPEND query based on your current Access table.

Create a duplicate table with the same fields, then run the append query to add the new records - you could create some key field (if there isn't one already), so that only new records would be added.

Use the duplicate table in place of the original table in any subsequent queries, and replace all connections so that they link to the new table instead.