not delete data if linked data source is deleted

%3CLINGO-SUB%20id%3D%22lingo-sub-786757%22%20slang%3D%22en-US%22%3Enot%20delete%20data%20if%20linked%20data%20source%20is%20deleted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786757%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone.%26nbsp%3B%20Have%20a%20bit%20of%20a%20problem%20I'm%20hoping%20to%20get%20help%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20that%20has%20reached%20it's%205k%20limit%20and%20it's%20causing%20me%20some%20issues.%26nbsp%3B%20I'm%20hoping%20I%20can%20link%20the%20SP%20list%20to%20Access%26nbsp%3B%20and%20use%20Access%20as%20the%20main%20storage%20place%20for%20everything%20and%20then%20delete%20items%20on%20the%20SharePoint%20list%20that%20is%2060%20days%20and%20older%20but%20%3CSTRONG%3E%3CU%3Enot%3C%2FU%3E%3C%2FSTRONG%3Edelete%20the%20item%20that%20is%20in%20the%20Access%20db.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAccess%20and%20SP%20need%20to%20be%20fully%20linked%20so%20if%20any%20updates%20are%20made%20to%20the%20SP%20items%2C%20except%20for%20deletion%2C%20tare%20also%20made%20to%20the%20Access%20back%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-786757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2016%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787341%22%20slang%3D%22en-US%22%3ERe%3A%20not%20delete%20data%20if%20linked%20data%20source%20is%20deleted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787341%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325149%22%20target%3D%22_blank%22%3E%40Bryan123%3C%2FA%3EJust%20a%20quick%20thought.%20How%20about%20if%20you%20make%20an%20archive%20table%20in%20Access%20that%20has%20the%20older%20data%2C%20a%20sharepoint%20list%20linked%20table%20and%20use%20a%20union%20query%20for%20any%20presentation%20of%20the%20whole%20set%20of%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20a%20thought.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-799671%22%20slang%3D%22en-US%22%3ERe%3A%20not%20delete%20data%20if%20linked%20data%20source%20is%20deleted%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-799671%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F325149%22%20target%3D%22_blank%22%3E%40Bryan123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EImport%20the%20table%20to%20Access%2C%20link%20the%20table%20also%20to%20a%20second%20table%20and%20then%20make%20a%20add%20query%20to%20add%20the%20newest%20data%20to%20the%20normal%20table%20from%20the%20online%20table.%20Run%20a%20second%20query%20to%20delete%20all%20the%20records%20what%20is%20older%20then%2090%20days%20in%20the%20online%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20thing%20to%20mention.%20The%20database%20will%20online%20not%20schrink%2C%20the%20size%20will%20remain%20the%20same.%20Only%20if%20you%20compact%20it%2C%20it%20will%20get%20a%20smaller%20size.%20This%20information%20in%20case%20it%20is%20the%20filesize%20what%20is%20limited.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi everyone.  Have a bit of a problem I'm hoping to get help with.

 

I have a SharePoint list that has reached it's 5k limit and it's causing me some issues.  I'm hoping I can link the SP list to Access  and use Access as the main storage place for everything and then delete items on the SharePoint list that is 60 days and older but not delete the item that is in the Access db.

 

Access and SP need to be fully linked so if any updates are made to the SP items, except for deletion, tare also made to the Access back up.

 

Is this possible

2 Replies
Highlighted

@Bryan123Just a quick thought. How about if you make an archive table in Access that has the older data, a sharepoint list linked table and use a union query for any presentation of the whole set of data. 

 

Just a thought. 

Highlighted

@Bryan123 

 

Import the table to Access, link the table also to a second table and then make a add query to add the newest data to the normal table from the online table. Run a second query to delete all the records what is older then 90 days in the online table.

 

One thing to mention. The database will online not schrink, the size will remain the same. Only if you compact it, it will get a smaller size. This information in case it is the filesize what is limited.