Checking dB for New Records Using DAO??
 

Hello again all,

Another question to all of you "in the know".

I would like to speed-up the process of reading updates to a dB. Right
now, between the write of one application and the read of this
application across a [very small 100 mbit] network takes about 2
seconds.

How can I pole a dB to check for new records without closing and
reopening the dB? Is there another way to refresh the dB connection so
that the record-set has the newest record? Or, is this simply a matter
of reducing the size of the record set? Is there ADO functionality I
could use that not in DAO? How do I speed this up?

Here's how I do it now...

Set eScalperDB = OpenDatabase("E:\My Databases\eScalper.mdb", False,
True)

.... (in another module that loops 0.3 seconds)....

Set rstTickDataRead = eScalperDB.OpenRecordset("Select * FROM
Table_Tick_Data WHERE Date_Stamp = #: & Date & "# ORDER BY Date_Stamp,
Time_Stamp", dbOpenDynaset)

eScalperDB.TableDefs.Delete ("Table_Tick_Data")

eScalperDB.Close
...........................

As you can see I am opening and closing the dB connection every time I
pole. I have found that even if I write to the dB (from another
application) and pole the dB (from this application) every one-third of
a second it still takes two seconds for the this application to update.

Any thoughts would be great!

Thanks!!!

Trip