ODBC and 'real time'

[krzysztof via AccessMonster.com]

Good Day!

i have a db that connects to an SQL Server, and the ODBC should be real time.


I have a form with fields that track info that is not currently being tracked
in the SQL system, so I created an Access db to be an 'extension'. the
problem is one field on my form needs to be 'real time'.
I have a drop down box that is connected to look up a field right to my odbc
connection table. based on what the user inputs, then shows related info
based on the input. the users complain that if they create an order in the
SQL system, in order to choose the new order number on the form, they must
close the db, and re-open it. I have tried different 'refresh' options, but
nothing seems to work. Any ideas?

TIA

~K

 

[david epsom dot com dot au]

You need to ReQuery, not ReFresh, to get new records.

You may need to force the requery by checking the record
count value of the drop down box.

You may wish to use a passthrough query for the drop
down box, so that the data does not pass through the
jet cache.

How is the data inserted into the database? You may
need to clear the write cache to write the data back
to the database.

By forcing the system to frequently write back
and refresh the cash, you can reduce delays, but not
eliminate them, and you will slow everything down.

A database system is not a real-time network communication
service. If you decide that you need a real-time network
communication service, you should use something like
tcp or udp, not a database system.


(david)