none
Restore previous Version of SharePoint list in Access Database RRS feed

  • Question

  • I'm using Access 2010 as a front end to work with Sharepoint 2013 lists. I would like to restore to the version of Jan1. I see accessDatabase from Jan 1but when I open it, it gets refreshed to current Sharepoint lists as it is Online with SharePoint. Is there a way I can disconnect it with SharePoint and get the data from Jan 1st?

    Thank you

    Wednesday, January 11, 2017 7:10 PM

Answers

  • Hi,

    Yes, restoring previous version of complete list is not available in Access, however, in SharePoint, we can restore all list items in a list using PowerShell commands:

    $list = $web.Lists["List1"]
    $items = $list.Items
    	foreach ($item in $items)
    	{
    		$Versions = $item.Versions      
    		if ($Versions.Count -gt 0)
    		{           
    			$Versions.Restore($Versions.Count - 1)          
    		}   
    	}

    Thanks

    Best Regards


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Friday, January 13, 2017 5:48 AM

All replies

  • Hi SharePointMadness,

    As I understand, Access is only a management tool for SharePoint 2013 list data. So if need to restore previous version of SharePoint list data, it is necessary to configure Version History in SharePoint 2013 list:

    About restore previous version for list, please refer the article below:

    Restore a previous version of an item or file in SharePoint

    Thanks

    Best Regards


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Thursday, January 12, 2017 7:08 AM
  • Thanks for the reply Jerry. But i cannot restore previous version for the complete list. I think its not doable through access.
    Thursday, January 12, 2017 3:12 PM
  • Hi,

    Yes, restoring previous version of complete list is not available in Access, however, in SharePoint, we can restore all list items in a list using PowerShell commands:

    $list = $web.Lists["List1"]
    $items = $list.Items
    	foreach ($item in $items)
    	{
    		$Versions = $item.Versions      
    		if ($Versions.Count -gt 0)
    		{           
    			$Versions.Restore($Versions.Count - 1)          
    		}   
    	}

    Thanks

    Best Regards


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Friday, January 13, 2017 5:48 AM