Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Tips and Traps When Developing Applications Using Source Code Control
 

 Note   The Microsoft Office Access 2007 Developer Extensions are required to use this feature. See Introduction to the Access 2007 Developer Extensions and Runtime for more information on how to obtain the Access Developer Extensions.

The following issues apply when you are using Microsoft Office Access 2007 and the Source Code Control component.

  • An object that is under source code control must always be checked out before you can make changes to the design of the object.
  • If you create a query using a query wizard, you are not prompted to add the query to source code control when the query is saved. To add this query to source code control, on the Source Control tab, in the Object Source Control group, click Add Objects To SourceSafe.
  • If you move, copy, or rename a database that is under source code control, you can no longer use the source code control features with that database. You can re-create the database from the source code control project and reenable source code control features. To do this, click the Microsoft Office ButtonButton image, click Developer, and then click Create from SourceSafe.
  • Each source code control project should contain only one Data and Misc. Objects object (.acd or .acb file). If you add a second Data and Misc. Objects object to a source code control project, you will get an error when you use the Share Objects, Create From SourceSafe, or Refresh Status commands.
  • Before you insert, update, or delete records that you want to be checked in, you must first check out the Data and Misc. Objects. When you don’t have Data and Misc. Objects checked out, the Latest Version command will retrieve the most recent version of Data and Misc. Objects, and it will discard any data changes that you may have made.
  • Before you create a table using a macro, a make-table query, or Visual Basic code, first check out the Data and Misc. Objects object. If you do not check out the Data and Misc. Objects object, the table will appear to be created and will even appear to be under source code control. But if you close the database and re-create it from the source code control project, or use the Latest Version command to retrieve the most recent version of the Data and Misc. Objects object, you will find that the table was not added to source code control.
  • When your team has finished development of an Access application, you will need to create a copy the Access database without source code control so that you can distribute or replicate it.

    To create a copy of the database without source code control, click the Microsoft Office ButtonButton image, click Save As, and then select the desired database format. The new database will not be under source code control.
  • You can work on a database even when you are not connected to the source code control provider. Before you disconnect from the server, check out the objects that you plan to modify.
  • If you open an object in design view using Visual Basic code, you are not prompted to check the object out. Any changes that you make are lost when you synchronize the source code control project with your database.
advertisement