Unanswered: HELP! Need Access DB to show realtime changes in different location
I was wondering about how access refreshes it's data within forms and it seems that it doesn't.
If i have a form open in one location on a network and update fields on the form the changes are not shown on the form opened in another location.
(I.e. if 2 users are in the same form at the same time and one adds a new record the other users form will not show this change).
Is there anyway that Access can be setup to show real-time changes over multiple locations?
Preferably without having to do a manual refresh by clicking a button or something.
All i want to do is show changes to a form instantly in different locations.