How to refresh multiple users buffers

[Dean Slindee]

We have a networked Access 2003 application (.adp) with a SQL Server 2000
backend. Changes made by one user to a data row are not visible to another
user viewing the same row unless both users quit the application. I presume
this is some type of buffer situation, where both users get complete buffers
(copies) of the data(base) when they launch the application. And then when
the first user moves off the updated row, the second user's buffer is not
automatically updated.



Is my analysis close to correct? Is there any way to force or accomplish a
refresh of one or many user's buffers?

How does Access work internally regarding these buffers?



Thanks in advance,

Dean S

 

[aaron.kempf]

are you talking about locking?

you just need to only ever load a single record at a time

that's your problem-- any database in the world will do it.

load a single record at a time and you won't have this problem

 

[aaron.kempf]

you can use me.refresh and it will only load changed data I believe

but more importantly; I would reccomend only viewing a single record
at a time


loading 5,000 records-- all it does is it makes your users wait longer

 

[Dean Slindee]

Perhaps I misuse or abuse the record source capabilities of Access. I have
always assumed that it was normal to use a table or a query for the record
source for any form. If I didn't source the full table to the form, then
the users would not be able to use the binoculars to do a search on any
field on the form against the table.
So then, every app would need a dedicated search form, which would transfer
control to the detail table maintenance form?

Thanks for replying.

Dean S