 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007How to refresh multiple users buffers
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 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 > 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 [quoted text clipped - 12 lines] > > Dean S 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 > 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 [quoted text clipped - 12 lines] > > Dean S 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 > you can use me.refresh and it will only load changed data I believe > [quoted text clipped - 24 lines] >> >> Dean S |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.