access via network and inranet

[bobbee25]

Have an Access application on the network, being updated by network clients. Accessing the same database in read mode using asp on the intranet.
When the asp page loads the data is ok, but if the network client changes the database, we can't get the asp to reflect the change. i.e. retrive other data w/asp and then go back and try to retrieve the changed data.

 

[onpnt]

how are you reloading the records from the database to reflect the updates?


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[bobbee25]

We are retrieving a days worth of data on a screen. Changing to a different day and then changing back to the original day again should reload the latest data from the db, as it does another read. But it doesn't.

 

[onpnt]

try setting the cache for the pages with the AddHeader, CacheControl and Expires methods

Response.Expires = 0Response.Expiresabsolute = Now() - 1 Response.AddHeader "pragma","no-cache" Response.AddHeader "cache-control","private" Response.CacheControl = "no-cache"

____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[onpnt]

Response.Expires = 0
Response.Expiresabsolute = Now() - 1 
Response.AddHeader "pragma","no-cache" 
Response.AddHeader "cache-control","private" 
Response.CacheControl = "no-cache"

format got messed up...


____________ signature below ______________
General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[bobbee25]

If they open the database with the network client, the webserver client receives a 'database locked' message ???