Article ID: 285828 - View products that this article applies to.
This article was previously published under Q285828
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Access 2000 version of this article, see 237938
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
Silent design changes (minor design changes) that are made to Microsoft Access-specific objects, such as forms, reports, macros, modules, or commandbars, may be discarded without warning.
The database has been opened by multiple users, and Microsoft Access cannot obtain an exclusive lock on the database.
This behavior is by design. In order to save design changes to any Access-specific objects (forms, reports, macros, modules, PivotTable lists or charts, and commandbars), Access must be able to obtain an exclusive lock on the database. If the database is currently in use by multiple users, Access cannot obtain an exclusive lock and cannot save the design change.
For additional information about Microsoft Access requiring exclusive locks for saving design changes, please see the following article in the Microsoft Knowledge Base:
283228Because all design changes require an exclusive lock in order to be saved, Microsoft Access may not warn you if the design change cannot be saved at the current time. If Access considers the design change to be a "major" change, such as modifying the design of a form, then you are warned if the design change cannot be saved at the current time because it cannot obtain an exclusive lock. However, if Access considers the design change to be a "minor" change, such as applying a filter to a form, then it silently discards the design change if it cannot obtain an exclusive lock. These two categories of design changes are known as "Major Edits" and "Minor Edits."
(http://support.microsoft.com/kb/283228/EN-US/ )ACC2002: Exclusive Lock Required for Saving Design Changes to Access Objects
Major EditsMajor edits are design changes that Access must be able to save, or that it must warn the user about if the change cannot be saved until Access can obtain an exclusive lock on the database. This prevents the Access developer from losing design changes without any warning. The following is a list of design changes that Access considers to be major edits:
Minor EditsMinor edits are design changes that are silent in nature, and that are discarded if Access cannot obtain an exclusive lock on the database. This prevents users from receiving a warning that their design change cannot be saved when they make a minor modification. The following is a list of design changes that Access considers to be minor edits:
Steps to Reproduce the BehaviorCAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Contact us for more help
Connect with Answer Desk for expert help.