ACC2002: Get Latest Version or Check Out Fails with Recovered Microsoft Access Object Under Source Code Control (275072)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q275072
Advanced: Requires expert coding, interoperability, and multiuser skills.

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

SYMPTOMS

When you delete a Microsoft Access database object that is under Source Code control, and you then recover the object by using Visual SourceSafe Explorer, when you click Get Latest Version or Check Out, the object is not made available in the Access database from which you deleted it. When Get Latest Version is initiated, the Source Code Control Status dialog box is displayed, but you do not get the recovered object.

RESOLUTION

To recover the object, use one of the following methods.

METHOD 1

In your local working folder, delete the <ObjectName>.acf file from the *.scc folder, and then perform the Get Latest Version action again. Note that the object is imported into the database.

METHOD 2

On the Tools menu in Access, point to SourceSafe, click Create Database from SourceSafe Project, and then re-create the Access database or project in the local working folder. This will make all the objects available, including the objects that were recovered by using Visual Source Safe Explorer.

STATUS

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

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Make sure that you have Access and Visual SourceSafe Server or Client Tools installed.
  2. Create a Visual Source Safe database to add the Access database or project.
  3. Open the Northwind sample database (in either Microsoft Access 2000 or Microsoft Access 2002 file format).
  4. On the Tools menu, point to SourceSafe, and then click Add Database to SourceSafe.
  5. Browse to the Visual SourceSafe database that you created in step 2, and then add the Access database.
  6. Create a new form, and then save it as Form1. When you are prompted, add Form1 to Source Code control.
  7. Delete the form that you just created, and then click Yes to also remove it from source code control.
  8. On the Tools menu, point to SourceSafe, and then click Run SourceSafe. This starts Visual SourceSafe Explorer.
  9. Right-click the project that contains the Access database, and then click Properties.
  10. Click the Deleted Items tab.
  11. Click Form1.ACF, and then click Recover.
  12. Switch back to Access, point to SourceSafe on the Tools menu, and then click Get Latest Version.
  13. Click to select Form1, and then click OK. Note that the Source Code control seems to be getting the form. However, the form is not available in the Access database.

REFERENCES

For additional information about how to set up Visual Basic Editor and Visual SourceSafe integration for multiuser development, click the article number below to view the article in the Microsoft Knowledge Base:

234865 MOD2000: How to Set Up Visual Basic Editor and Visual SourceSafe Integration for Multiuser Development

Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kbbug kbnofix KB275072
©2003 Microsoft Corporation. All rights reserved.