If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Requery external linked table?
Hi everyone... This is ia repost b/c I didn't get any answers to the
previous post... and I can't believe this isn't possible to do!! I have Googled high and low on this and could not find an answer: how do you use VBA in Access 2003 to requery the data in an external linked table? I have linked an Access 2003 table to a SharePoint 2003 (WSS) site list (let's call it "tblMyList"), and on a button click in a non-bound form I open a recordset on the table, iterate through it, and may update the rows or do other operations based on the list/table content. The problem is that as long as my processing form is open (the form is NOT bound to the recordset or table), I cannot seem to get the linked table to refresh and show updates in the recordset in Access when someone has edited the list in SharePoint. The only way that the external table data is refreshed is if I close the form and re-open it (not optimal!). I have tried .Requery, closing the recordset, iterating through the db TableDefs and executing .RefreshLink on it, etc etc. What am I missing? Code below for reference... Thanks in advance, Keith ' I am opening the external linked table Dim db As Database, rs as RecordSet Set db = CurrentDb Set rs = db.OpenRecordset("tblMyList") ' have tried dbOpenSnapshot and dbDynaset : rs.Requery Me.Refresh |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Requery linked tables in code? | Keith B. | General Discussion | 2 | November 23rd, 2004 07:47 PM |
changes in a table do not show up in linked form - why? | edleonard8 | Using Forms | 1 | September 17th, 2004 08:44 PM |
how to pull most recent date from a linked table | General Discussion | 2 | August 29th, 2004 06:34 PM | |
Convert linked table design to local table | Dave Venus | Database Design | 5 | June 17th, 2004 12:05 PM |