the effects of changing allowedits

[Guest]

I have an MDB being used by several users. Some of the forms change the
allowedits properties depending on the date of the timestamp on the record.
If One person opens the form and as it is in use it changes the allowedits
from true to false. If another person opens the same form at the same time,
will the change on the allowedits be reflected in the form when the second
person opens it or will it open in its original state?

 

[Allen Browne]

Each person opens Access on their machine, so the instances are different.
Hence each person can use the form to view different records, and the code
(presumably in Form_Current) will apply to the record the user is viewing.

Well, that's how it's supposed to work anyway. In practice, if you have
multiple users accessing the same data, you would be advised to split the
database so each user has a separate copy of the front end, and their tables
are linked to the same data. If that's a new concept, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html