Split DB Not Refreshing

rajeshsarin

Registered User.
Local time
Today, 21:55
Joined
Sep 25, 2009
Messages
50
I have a split Access DB with about 12 users each having their own front end.

Often we note that once a user enters data the other users cannot see it till they close their database and re-start it. It is a new problem, never use to happen earlier.
 
It has always been an issue. What version of Access are you using? Once a user has saved their data then the other users can see it *if* they requery the table.
 
hey,
maybe you could put a button to refresh form data and to requery it.
under the button u write the code docmd.requery
docmd.refresh
or u could try with a timer under the forms properties to do a auto refresh or requery every few seconds.. but i haven't tried that as yet..

hope this helps..
regards
abhi
 

Users who are viewing this thread

Back
Top Bottom