Can you edit a layout while others are accessing the database in which the layout is provided?
If you mean edit the layout design, then yes. This is something that I do frequently. It should be done with caution, however as your layout changes may catch a user by surprise and in the middle of what they are doing, great care needs to be taken. If doing this during "business hours", such changes need to be modest. Any significant changes need to include advance warnings to the user that tell them what will be changed and why.
Ways to mitigate the "surprise factor":
If adding a new feature to the layout, use Hide Object When to make the feature invisible to everyone but you or everyone but fellow "[full access]" users until you are finished with the design and testing.
Duplicate the layout. Make all changes on the duplicated layout. Once you are satisfied that the new layout design change is finished and works correctly, use the clip board to copy and paste all layout objects from your copy of the layout into the "production" copy of the layout at an after hours time or during a maintenance shut down. Make sure that your users know that a change is coming and why. (I sometimes shoot screen capture videos of the layout demonstrating the changes and how to use them in order to get user feed back, user buy in and to let them know how things will change.)
Many thanks. Just what I wanted to know. Cordially, Dave
+1 to working on a duplicate layout OR using data seperation and working on a dupe file
FWIW, I am often in the position to work on layout design during the work day.
I will typically warn users by putting a text box on the layout saying:
"I'm working on this layout today, things may appear or shift while you are working" or some such.
Then I will leave layout mode periodically to "stick" the changes as I go through each stage.
So far...no complaints (even with some pretty massive design changes including tab controls and color changes).
Thanks for the good idea. Dave
Retrieving data ...