microsoft.com Home  
Microsoft
http://www.microsoft.com/office/ork  
Upgrading to Access 2000

Saving Design Changes to a Shared Access Database

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.

Top

Saving major and 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:

Top

Sharing Access database design and development

If you are going to share the design of an Access database, consider using the following strategies:

Top

See also

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