With the release of Microsoft Office Access 2007, the Access 2007 Developer Extensions and the Access 2007 Runtime are available as free downloads. These utilities provide database developers with tools to package and deploy a database, create database templates, and integrate a database with source code control systems, such as Microsoft Visual SourceSafe.
For more information about downloading and using the Access 2007 Developer Extensions or the Access 2007 Runtime, see the links in the See Also section.
Use the Access 2007 Developer Extensions
When you install the Access 2007 Developer Extensions on your computer, a new section, called Developer, is added to the menu that appears when you click the Microsoft Office Button in Access 2007.
This new section of the menu includes the following commands:
Package Solution Use this wizard to create a Windows Installer Package (.msi file) that installs your database and any supporting files on your users' computers. Your installation package can optionally include the Access 2007 Runtime or prompt your users to download the Access 2007 Runtime. After you install the Access 2007 Developer Extensions on your computer, you can start the Package Solution Wizard by doing the following:
Click the Microsoft Office Button , point to Developer, and then click Package Solution.
Save As Template Use this command to create database template (.accdt) files that can be featured on the Getting Started with Microsoft Office Access page. After you install the Access 2007 Developer Extensions on our computer, you can start the Save As Database Template Wizard by doing the following:
Click the Microsoft Office Button , point to Developer, and then click Save As Template.
Source Code Control Use this command to integrate your database with a source code control system. If you have installed a source code control system on your computer, such as Visual SourceSafe, a third option becomes available in the Developer section of the menu that appears when you click the Microsoft Office Button . For example, if you installed Visual SourceSafe, the Create from SourceSafe option appears on the menu. You can use this feature to integrate your database with the source code control system.
Source code control systems are helpful in situations where there are multiple developers making design modifications to a database. You can check out any database object from a source code control system, and then modify the design of that object. For example, one developer can check out a report, make design modifications to that report, and then check it back in. While the object is checked out, no one else can make changes to it. This helps prevent the loss of work that can occur when more than one developer tries to modify the same object at the same time. By using source code control, you can also see the history of changes that were made to your objects each time they were checked out and, if necessary, revert to previous versions of the objects.
If a source code control system is installed on your computer, after you install the Access 2007 Developer Extensions, you can start the source code control system from within Access 2007 by doing the following:
Click the Microsoft Office Button , point to Developer, and then click Create from source code control program name.
Note: The name of the command on the menu may vary, depending on which source code control system is installed. For example, if Visual SourceSafe is installed, the command name is Create from SourceSafe.
For further assistance with using a source code control system, consult the Help system that was installed with that program.
Note: The Access 2007 Developer Extensions do not include the Property Scanner and the Custom Startup Wizard that were included in previous versions of Microsoft Access.
To download the Access 2007 Developer Extensions, click the link in the See Also section.
Use the Access 2007 Runtime to deploy applications
The Access 2007 Runtime is a free program that you can use to distribute Access 2007 applications that you have built to users who do not have Access 2007 installed on their computers. Users who open an application by using the Runtime cannot modify the forms, reports, and other objects the application contains. All design-related functionality is either removed or disabled, including the default Ribbon, the Quick Access Toolbar, and the Navigation Pane. Therefore, you must design your application so that all of the functionality that a user requires is included in its forms, reports, and custom Ribbons.
The Access 2007 Runtime is available as a free download from the Microsoft.com Download Center. You do not need to buy any software to redistribute the Runtime, nor is there a limit on the number of users that you can distribute the Runtime to. In addition to distributing the program yourself, you can instruct your users to download the program themselves from the Download Center.
To download the Access 2007 Runtime, click the link in the See Also section.