Home

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

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

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

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies