MOD2000: Changes to Access Database Are Saved Without .ACB Checked Out (234823)


The information in this article applies to:

  • Microsoft Office 2000 Developer
  • Microsoft Access 2000
  • Microsoft Visual SourceSafe for Windows 6.0
This article was previously published under Q234823
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

If you do not check out Data and Misc. Objects (*.acb) from source code control before you make changes to the project properties of your database, your changes are saved locally but you are not able to check them into source code control. When Data and Misc. Objects is checked out at a future time, the local changes are overwritten.

CAUSE

Changes to VBA project properties should not be saved at all unless Data and Misc. Objects is checked out. However, the VBA Source Code Control Integration Add-in allows these modifications to be saved locally. There is no way to check these changes into source code control unless you check out Data and Misc. Objects and make the changes again.

RESOLUTION

Check out objects in your database before you make modifications that you intend to save. Always check out Data and Misc. Objects before you make changes to the project properties of your database.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Add a database to source code control, and make sure that Data and Misc. Objects is checked in.
  2. Open the Visual Basic Editor (ALT+F11), and open the Project Properties dialog box. On the Tools menu, click <Your database name> Properties.
  3. Click No when you are prompted to check out Data and Misc. Objects. Note that you are warned that your changes will not be saved.
  4. Make some modifications in the Project Properties dialog box, for example, Project Name.
  5. Close the Project Properties dialog box, and then close and reopen the database. Note that the changes that you made persist in the database.
  6. Check out Data and Misc. Objects. Note that your changes are overwritten by the .acb under source code control.
Modification Type:MinorLast Reviewed:7/14/2004
Keywords:kbbug kbpending KB234823
©2004 Microsoft Corporation. All rights reserved.