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 Button
, 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 Button
, 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.