Normal Access behavior?

[Sandra]

Hi -- I'd appreciate any help you could offer with this!

Scenario: Shared database, FE & BE both located on
server; users have shortcut on desktop pointing to FE on
server

User 1 enters a new record

User 2 cannot see/find the new record unless shift+F9
(requery) is pressed

Normal Access behavior or is there something I can do to
programmatically refresh the records?

Thanks in advance!

 

[Rick Brandt]

Hi -- I'd appreciate any help you could offer with this!

Scenario: Shared database, FE & BE both located on
server; users have shortcut on desktop pointing to FE on
server

User 1 enters a new record

User 2 cannot see/find the new record unless shift+F9
(requery) is pressed

Normal Access behavior or is there something I can do to
programmatically refresh the records?

Completely normal. To expect otherwise you would have to have Access
constantly re-reading from disk which would be very inefficient.

You can issue the Requery command in code and even do so in the Timer event
so it happens at regular intervals. However; the Requery will take the
user back to the first record in the form. Not something you would want to
do unless the user is initiating it.

 

[Bruce M. Thompson]

Might I also suggest that the FE be located on each user's machine? If it

crashes or gets corrupted, only that user is down.

It could also help avoid the corruption in the first place, along with
preventing numerous other problems. See the following page at Tony Toews' web
site for more information that one can't live without:

http://www.granite.ab.ca/access/splitapp.htm