ACC2002: New Access 2002 Properties Not Persisted in Visual SourceSafe (279738)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q279738
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 check out a Microsoft Access object from a Microsoft Visual SourceSafe project, you notice that previous changes that you made to new Access 2002 properties were not saved.

CAUSE

Your Microsoft Access database (.mdb) or project (.adp) file has not been converted to Microsoft Access 2002 format.

RESOLUTION

Remove the database or project file from Visual SourceSafe, convert it to Microsoft Access 2002 format, and then create a new SourceSafe project from it. To do this, follow these steps:
  1. Start Microsoft Access 2002.
  2. Open the database or project file, and then log into the Visual SourceSafe server when you are prompted.
  3. If you have objects currently checked out, point to SourceSafe on the Tools menu, and then click Check In.
  4. In the Check In Objects to SourceSafe dialog box, click All in the Object Type box.
  5. Click Select All, and then click OK. This checks in all of the objects that you had previously checked out.
  6. On the Tools menu, point to SourceSafe, and then click Get Latest Version.
  7. In the Get Objects From SourceSafe dialog box, click All in the Object Type box.
  8. Click Select All, and then click OK. This ensures that the latest version of each object has been copied to your computer.
  9. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database. Click Yes when Microsoft Access prompts you to remove it from Source Code Control.
  10. On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2002 File Format
  11. Enter a path to create the new file, and then click Save.
  12. On the Tools menu, point to SourceSafe, and then click Add Database to SourceSafe.
  13. Click Yes when Microsoft Access prompts you that the database must be closed.
  14. Enter your user name and password in the Visual SourceSafe Login dialog box.
  15. In the Add to SourceSafe Project dialog box, enter a new project name in the Project Name box, and then click Create. Then click OK to close the Add to SourceSafe Project dialog box.
  16. In the Add Objects to SourceSafe dialog box, click All in the Object Type box, and then click OK.
  17. Click OK when Microsoft Access alerts you that the command was completed successfully.

STATUS

This behavior is by design.

MORE INFORMATION

If you are using a Microsoft Access 2000 file, the Microsoft Access Source Code control intentionally prevents new Microsoft Access 2002 properties from being checked into the SourceSafe project. This is designed to prevent Microsoft Access 2000 users from checking out an object with properties that Access 2000 does not recognize.

If the file is in Microsoft Access 2000 format, it is possible for a Microsoft Access 2000 user to open the file and try to check out an object from the SourceSafe project. If the new Access 2002 properties were persisted in the SourceSafe project, Microsoft Access 2000 could not load the object because it would not recognize the new 2002 properties.

Therefore, when you add a Microsoft Access 2000 file to Visual SourceSafe, it only persists the Access 2000 properties. Visual SourceSafe persists Access 2002 properties if the file is in Microsoft Access 2002 format. Because Access 2000 users would not be able to open an Access 2002 file, the situation described in this article would not occur.

Steps to Reproduce the Behavior

  1. Start Microsoft Access 2002.
  2. Open the sample database Northwind.mdb and verify that it is a Microsoft Access 2000 file.
  3. On the Tools menu, point to SourceSafe, and then click Add Database to SourceSafe.
  4. Click Yes when Microsoft Access prompts you that the database must be closed.
  5. Enter your user name and password in the Visual SourceSafe Login dialog box.
  6. In the Add to SourceSafe Project dialog box, type Northwind in the Project Name box, and then click Create. Then click OK to close the Add to SourceSafe Project dialog box.
  7. In the Add Objects to SourceSafe dialog box, click All in the Object Type box, and then click OK.
  8. Click OK when Microsoft Access alerts you that the command was completed successfully.
  9. Open the Customers form in Design view, and click Yes when Microsoft Access prompts you to check the object out.
  10. View the property sheet of the form.
  11. Click the Format tab, and then set the Moveable property to No.
  12. On the File menu click Save, and then close the form.
  13. Click the Customers form in the Database window.
  14. On the Tools menu, point to SourceSafe, and then click Check In.
  15. In the Check In Objects to SourceSafe dialog box, make sure that the Customers form check box is selected, and then click OK.
  16. Close the database.
  17. On the Tools menu, point to SourceSafe, and then click Create Database From SourceSafe Project.
  18. Enter your user name and password in the Visual SourceSafe Login dialog box.
  19. In the SourceSafe Project to Download box, click Northwind, and then select a path to a folder that is different from where the original Northwind project is stored. Click OK. Note that the Northwind objects are downloaded into a new database.
  20. Click OK when Microsoft Access alerts you that the command was completed successfully.
  21. Open the Customers form in Design view, and then click Yes when Microsoft Access prompts you to check the object out.
  22. View the property sheet of the form.
Note that the Moveable property has been reset to Yes, even though you previously set it to No and checked in the design changes for the object.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbprb KB279738
©2004 Microsoft Corporation. All rights reserved.