discount windows 7 professional Code to refresh Sh
 

We have an internal Accessibility Discussion alias that's used for by MS workers to obtain solutions to their issues. A short time ago I saw a quality query about find out how to refresh SharePoint lists. Here is the problem…
SharePoint lists which have been connected to Access 2007 database files is not going to reflect structural alterations to your lists in SharePoint.  Once someone variations list schema, you can continue to use the linked lists in Access for read-only purposes without even knowing that the list structure has changed.  You cannot,microsoft office Home And Student 2010 64 bit key, however,cheap microsoft windows 7 32bit key, update the list data from within Access after a structure change unless you first refresh the list.  Beck wrote a handy little function to call refresh on all SharePoint link tables.
Sub RefreshSharePointLinks()    'DoCmd.Hourglass True Dim dbs As Database
   Set dbs = CurrentDb()

 

   For Each tbl In dbs.TableDefs
      If (Mid(tbl.Name, 1, 1) <> "~") And ((tbl.Attributes And dbAttachedTable) = dbAttachedTable) Then
         If Left(tbl.Name,win 7 32bit key, 21) <> "User Information List" Then
            If Left(tbl.Connect,discount windows 7 professional, 3) = "WSS" Then
               sql = "SELECT * FROM [" & tbl.Name & "];"
               Set rst = dbs.OpenRecordset(sql, dbOpenDynaset)
               If Not rst.Updatable Then
                  DoCmd.SelectObject acTable, tbl.Name,microsoft office Home And Student 2010 product key, True
                  DoCmd.RunCommand acCmdRefreshSharePointList
               End If
            End If
         End If
      End If
   Next
 
  'DoCmd.Hourglass False
  Sub
 
Next week I expect to tell you more about what Tom is doing with SharePoint.
Cheers!
Updated 10/20/2009 – Tom added a check for “WSS” in the connection string to handle other connected sources that are not from WSS and a check for updatability.