benbakelaar
IS-IT--Management
i have my database on a network server, and all 3 users are directly accessing it in shared mode w/record-locking turned OFF.
i have the main form set so that when a change is made, the form is closed and reloaded. however, if multiple users have the database open, any changes made, for example, by user 1 do not show on user 2's screen until they fully close and re-open the database.
is there any way i can push the changes permanently to the table being modified, so that when the form reloads it reflects the changes made by any user, not just the one who has it open?
i have the main form set so that when a change is made, the form is closed and reloaded. however, if multiple users have the database open, any changes made, for example, by user 1 do not show on user 2's screen until they fully close and re-open the database.
is there any way i can push the changes permanently to the table being modified, so that when the form reloads it reflects the changes made by any user, not just the one who has it open?