open exclusive

[Sher]

Hi all,
I am not understanding the open exclusive option. I understand that it is
to keep users from making changes that would cause problems while users are
in the database. But I am not understanding as to when a user needs the open
exclusive option allowed. Does a user who is only allowed to modify reports
need open exclusive under database to modify the heading on a report?
Please see my other posts.
Thanks in advance,
Sher

 

[Arvin Meyer [MVP]]

One a single user can be in the database when design changes are made, in
order for those changes to be saved. That's because Access now uses a
monolithic save model, which greatly reduces chances of corruption. That
said, ALL multi-user databases should be split. The data back-end is running
on the server, and the linked front-ends are running from each user's
workstation. Using that model, the user charged with making design changes
can easily do so, then distribute those changes at a convenient time.