Microsoft KB Archive/162057

= ACC: Design Change Not Visible to All Users of Shared Database =

Article ID: 162057

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q162057



Advanced: Requires expert coding, interoperability, and multiuser skills.



SYMPTOMS
When using Microsoft Access in a shared network environment in which all users of a database have the ability to create and modify modules and create and modify form and report objects that contain modules, newly created or modified objects will have the following behavior.

In Microsoft Access 97

--

  New or modified modules and new or modified form and report objects that contain modules will appear in the Database window, but other users will not be able to open the objects or see the changes made to existing objects until they close and reopen the database.

In Microsoft Access 7.0

---

  New or modified modules and new or modified form and report objects that contain modules will not appear in the Database window for other users of the database until they close and reopen the database.



RESOLUTION
To resolve this problem do one of the following.

In Microsoft Access 7.0
  Users who create or modify modules or form and report objects that contain modules in a shared database will need to make sure other users of the database close and reopen their copies of the database when changes are made.

In Microsoft Access 97
  Users who create or modify form and report objects that contain modules can take advantage of the new lightweight forms and reports. Lightweight forms and reports do not contain class modules. Therefore, lightweight forms and reports can be created or modified while the database is open and still be available to other users of the database.   Users who create or modify modules will need to have all users close and reopen their copy of the database when changes are made.



MORE INFORMATION
Some of the problems that may be encountered when users are sharing a database in a multiuser environment and all users are creating new objects or modifying existing objects are as follows:


 * If one user creates an object in a shared database, another user may unknowingly create the same object.
 * One user's changes can supersede another user's changes.
 * If one user makes a change to a Visual Basic for Applications procedure, other users can't run the updated Function or Sub procedure until they close and reopen their copy of the database.
 * If one user makes changes to objects that are dependent on one another, other users may open inconsistent versions of the objects.
 * In Microsoft Access 97, newly created objects appear in the Database window, but they cannot be opened.

Steps to Reproduce Problem
 Share the sample database Northwind.mdb on your server. To do this, do the following:

 Set up a shared folder on a network server. You may need to obtain your network administrators help to do this. Place a copy of the sample database Northwind.mdb on the network server.</li> Make sure the database is set to open in a shared mode.</li></ol>

NOTE: This option is set on the Tools menu under Options.</li> Connect to the network server from two computers.</li> Open the Northwind.mdb database on both computers.</li> On computer one, make a copy of the Customers form and saved it as Customers1.</li>  On computer two, click the Forms tab to see if the copy of the Customers form (Customers1) appears in the Database window. You should see the following behavior.

In Microsoft Access 7.0:

<pre class="fixed_text">     The newly created object does not appear in the Database window.

In Microsoft Access 97:

<pre class="fixed_text">     The newly created object appears in the Database window, but you cannot open it. </li> Close and reopen the shared copy of Northwind.mdb on computer two.</li></ol>

Note that you can now see and open the Customers1 form in the Database window.

<div class="references_section">