Microsoft Knowledge Base Email Alertz
All KB/RSS Links  |  Hot Kb!  |  New Kb!  |  Scott Cate  |  FAQ / KB  |  Web Hosting  |  Unsubscribe  

(275072) - 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...

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.
Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks
Article ID: 275072 - Last Review: September 25, 2003 - Revision: 3.0

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

View products that this article applies to.
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).

On This Page

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.
Back to the top

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.
Back to the top

STATUS

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

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.
Back to the top

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  (http://kbalertz.com/Feedback.aspx?kbNumber=234865/EN-US/ ) MOD2000: How to Set Up Visual Basic Editor and Visual SourceSafe Integration for Multiuser Development
Back to the top
APPLIES TO
  • Microsoft Access 2002 Standard Edition
Back to the top
Keywords: 
kbbug kbnofix KB275072
Back to the top
        

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate

Michael Freidgeim - http://www.thespoke.net/MyBlog/MNF/MyBlog.aspx
Written: 5/3/2005 5:04 PM
I had restored corrupted ADP from older backup and tried to get the latest version of some files. It did nothing until I deleted the corresponding files <ObjectName>.ac<?> from the local working *.scc folder(as recommended in method 1). After this Get Latest Version worked correctly.



Copyright © 2002-2007 KBALERTZ.COM.  All Rights Reserved. Terms / Privacy. Discount ASP.NET Hosting