microsoft.com Home | |||
http://www.microsoft.com/office/ork |
You cannot save design changes to a Microsoft Access database while other users are sharing the Access database with you. The only way to ensure that changes are saved is by opening the Access database in exclusive mode.
In general, when you are working in a database in shared mode, and you try to make a design change to an item or to a database object that is not a table or a query, Access temporarily promotes you to exclusive mode for the Access database — if you are the only user of the Access database at that time. When you save all your design changes, and close all the Design view windows, Access returns the Access database to shared mode. In the interim, other users cannot open the Access database.
If another user has the Access database open in shared mode, and you try to make a major design change such as modifying a form, Access alerts you that you might not be able to save your changes. However, if another user has the Access database open in shared mode, and you try to make a minor design change such as changing printer settings, Access does not alert you that you might not be able to save your design changes. In both cases, wait until you are the only user of the Access database so that you can save your major design changes, and Access can save your minor design changes.
If you are not the only user who has the Access database open, Access alerts you when you might not be able to save the following major design changes:
If you are not the only user who has the Access database open, Access does not alert you when you might not be able to save the following minor design changes:
If you are going to share the design of an Access database, consider using the following strategies:
For information about sharing an Access database on a network, see Microsoft Access online Help.
Topic Contents | Previous | Next | Top Friday, March 5, 1999 © 1999 Microsoft Corporation. All rights reserved. Terms of use. | ||
License
|