MOD2000: Undoing Checkout in Visual SourceSafe Deletes New Tables and Data Access Pages (236479)
The information in this article applies to:
- Microsoft Office 2000 Developer
- Microsoft Access 2000
This article was previously published under Q236479 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
SYMPTOMS
When you undo the checkout of Data and Misc. Objects for a Microsoft Access database under Microsoft Visual SourceSafe control, you lose any tables or links to a data access page that you created after you checked out the object.
CAUSE
Visual SourceSafe stores all of the tables and links to pages in Data and Misc. Objects as a single object. Therefore, if you undo the checkout of that object, Visual SourceSafe reverts to the stored version.
RESOLUTION
The stored version of Data and Misc. Objects does not contain any information about the new table. After you undo the checkout, there's no way to recover the new table.
However, the HTML file for the data access page is not part of Data and Misc. Objects. Therefore, the HTML file of the new page remains in the folder where it was saved. You can create a new link to the HTML file. To do so, follow these steps:
- Remove the database from Visual SourceSafe control.
- Open the database.
- In the Database window, click Pages under Objects, and then click New.
- In the New Data Access Page dialog box, click Existing Web Page, and then click OK.
- Locate the existing HTML file and click Open.
- On the File menu, click Save.
- Add the database back to Visual SourceSafe control.
For more information about removing a database from Visual SourceSafe control, click Contents on the Help menu, click the Index tab in Visual SourceSafe Help, type the following text:
and then double-click the selected text to go to the "files, delete and recover" topic.
Modification Type: | Minor | Last Reviewed: | 7/15/2004 |
---|
Keywords: | kbprb KB236479 |
---|
|