I am using a User Control that reads and writes data to an Access Database
using OLE DB classes (OleDbConnection...)  I believe the control is storing
data locally in a DataSet which populates a DataGrid.

My application is trying to read and write data to this same database
directly and I'm using a simple ADODB connection.  The trouble is that when I
update the database the changes are not always reflected in the control's
local copy.

It seems the OLE DB connection polls for changes to the DB at an interval of
~5s.  If I select a tab which contains the DataGrid within the ~5s the data
is out of sync.  If I wait longer than ~5s after the DB update then
everything remains in sync.

Ideally the user control would refresh its DataSet before displaying the tab
with the DataGrid.  As it is it only uses the automatic synchronization
(polling).  To make matters worse, when tab is changed the control overwrites
my changes to the DB with the contents of the DataGrid which it believes it
most up to date.

My question, is there anything I might do to the DB that would force the
control to update?  I have a feeling that this is a long shot...

Thanks,

Terrence