Free Advertising Forums | Free Advertising Board | Post Free Ads Forum | Free Advertising Forums Directory | Best Free Advertising Methods | Advertising Forums - View Single Post - discount windows 7 professional Code to refresh Sh

**titejj52** · 03-14-2011, 06:46 AM

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.

03-14-2011, 06:46 AM	#1
titejj52 Sergeant First Class Join Date: Mar 2011 Posts: 113	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.

Sponsored Links