Requery linked tables in code?

[Keith B.]

Hi everyone... I have Googled high and low on this and could not find an
answer: 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 bound 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

 

[Roger Carlson]

Instead of CurrentDb, try DBEngine(0)(0)

Set db = DBEngine(0)(0)


--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


This is one of the few instances where it actually makes a difference.

 

[Keith B.]

Thanks, but that didn't change anything.

Instead of CurrentDb, try DBEngine(0)(0)

Set db = DBEngine(0)(0)


--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L


This is one of the few instances where it actually makes a difference.