Creating New Solutions from a Template

See Also

You can create new team solutions on the server using solution templates. A solution template is created using the Access Workflow Designer and contains all of the information required to create the SQL Server database and Web pages that users see. Team templates can be stored in a template directory located in the modSystem database or saved to a file (*.tpl) that can be exported for use on other servers.

In the typical team solution development cycle, a developer creates a team solution using the Access Workflow Designer and then creates a template for the solution. Solution owners then can use the templates to create team solutions on any server that has the Access Workflow Designer server components installed. Using the Team Solutions Manager, a solution owner can import and export template files, making it easy to share templates.

The New Team Solutions wizard is used to create new solutions from templates available in the template directory. This wizard walks you through the process of selecting a template and defining team solution properties and then creates an instance of the team solution in the designated location.

Note   Before creating a team solution, you must have the appropriate permissions on the server for both the database and the Web site. For more information, see Creating Accounts, Logins, Roles and Users.

To create a new team solution on a server

  1. Start the New Team Solutions wizard. For details about launching the wizard, see Accessing the Access Workflow Designer Tools.

  2. In the Choose a Template page, select a server, click Refresh, and then select a template to use to create a solution.
  3. Specify a title and destination for the new solution.
  4. Associate SQL Server logins with database roles to identify who will access to the solution and the roles to which they belong.

    Note   The new SQL Group or User must have a valid Windows NT login. If you add a SQL user who does not have a valid Windows NT login, creation of the team solution will fail.

    For more information about roles and users, see Creating Database Roles.

  5. Create an Access Project file if you want to be able to use Access 2000 to customize or modify the team solution once it is created.

  6. When you click Finish, the wizard accomplishes the following tasks:

Note   If the team solution contains offline publications, you can use the SQL Server Enterprise Manager Replication Monitor to verify that the publications were initialized properly. It is also recommended that you monitor the performance of your publications after the solution has been created. If users report problems with the publication, the Replication Monitor can help troubleshoot the issues.

The Team Web Site

New team Web sites are created as follows: