This project is read-only.

How to Create a New Release

This sections describes the steps necessary to create a new release of the AccessNetView. Essentially it removes all things that are not necessary to just /use/ the control in a database project. These things are source control bindings and the unit test environment.


  1. Make sure to appropriately increment the version number prior to creating a release. For that visit the unit test class zTST_Info. AccessNetView follows the rules of Semantic Versioning.
  2. Make sure all tests pass.
  3. Make sure everything is checked in.

Step by Step Instructions

The following steps describe how to make a new release of NetView:
  1. Create a new mdb based on the latest version. Use a new Access instance for that and there choose Create from SourceControl command.
  2. Close Access
  3. Create a temporary working directory for all subsequent steps. This working directory must be outside the folder mapped to your TFS-workspace.
  4. Put a copy of the latest mdb into the working directory
  5. Open that copy in Access - hold down the shift-key to bypass the AutoExec macro.
    1. (If you get the message that the database file is read only, close Access, remove the read-only flag in the file's properties in Windows Explorer and open the file again in Access. Proceed with the following step.)
    2. You will get the message "This database was named '<OldPath>', but has been moved, copied or renamed. Source code control feature will be disabled.". - Click on Ok.
    3. With Access 2007/2010 you might get another message that a macro could not run. This is due to the AutoExec that tries to call VBA code what might be disabled for the database location.
  6. Compact and repair that database - You will get the message "Would you like to remove the compacted database from Source Code Control?". - Click on Yes. That's what we want.

Prepare the playground file

  1. Delete the AutoExec macro
  2. Delete the table zTST_TestTable
  3. Change to the Visual Basic Editor (Alt + F11)
  4. From the Tools menu, sub menu AccUnit, choose "Remove Environment". - Click "Yes" on the message box.
  5. Compile the project - There may not be errors. If you encounter a compilation problem you need to fix it, check in and perform the steps from the top again.
  6. Compact the database once more. In the case of Access 2003 you might have to close Access before.
  7. Close Access
  8. Make a copy of the file and rename it to NetView_Playground.mdb
  9. You can delete the folders "Tests" and "NetView.scc".

Prepare the plain control file

  1. Open the file NetView.mdb in Access 2003 (!)
  2. Delete all tables
  3. Delete all forms except the form NetViewControl
  4. Delete all modules named "_*" (beginning directly with an underline)
  5. Delete all modules named PG_*
  6. Delete the reference to the TypeLibInfo Dll (tlbinfo32.dll)
  7. Compile the project - In the case of errors: back to the start
  8. Compact the database once more
  9. Close Access

Package the release

  1. Add the content from folder ReleaseMaterial to your working directory.
  2. Pack the content of your working directory into a zip file and name it like NetView_v<VersionNumber>.zip, e.g.
  3. Upload it as new release to the project site here on CodePlex - Include some information about the latest highlights.

Further Reading

Working with the Source Code in Microsoft Access


Last edited Mar 8, 2013 at 5:01 AM by Baula, version 29


No comments yet.