Normal Access behavior?

  • Thread starter Thread starter Sandra
  • Start date Start date
S

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!
 
Sandra said:
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?
Click to expand...

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.
 
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. As it is now, they would
all be down. You should see improvement in performance as well.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups
 
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.
Click to expand...

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
 
Back
Top