Forum Discussion
not delete data if linked data source is deleted
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 A...
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.