Microsoft KB Archive/234823

= MOD2000: Changes to Access Database Are Saved Without .ACB Checked Out =

Article ID: 234823

Article Last Modified on 7/14/2004

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition
 * Microsoft Access 2000 Standard Edition
 * Microsoft Visual SourceSafe 6.0 Standard Edition

-



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.



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  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.

Additional query words: pra

Keywords: kbbug kbpending KB234823

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.