Registering a Solution Database

See Also

Once you have a SQL Server database created that meets the requirements to be a team solution, you can use the Database Registration wizard to begin adding workflow features to your solution.

Before registering your database, be sure your schema meets the team solution requirements. For details, see Planning a Team Solution and Team Solution Development Guidelines.

There are two ways of launching the Database registration wizard, using an Access project (*.adp) or from the Access Workflow Designer shortcut on the Start menu.

To register a database from Access

  1. Open your database Access project (*.adp). For details, see Using Access to Create the SQL Server Database.

  2. From the Access toolbar, click Access Workflow Designer.

  3. If the database has not been registered as a team solution, the Database Registration wizard appears.

  4. On the Registration page, enter your team solution name, an optional description, and the location of your Web URL (this should be the name and location of a FrontPage Web, for example, "http://<YourServer>/WFTracker"). Accept the defaults, or type your own data.

  5. Click Next, and then click Finish.

Once processing is complete, the Access Workflow Designer appears with the solution and you can begin developing your solution. For information about the steps for creating a team solution, see Developing a Team Solution.

To register a database from the Access Workflow Designer Start menu shortcut

  1. From the Start menu, open the Access Workflow Designer. For details about finding tools, see Accessing Access Workflow Designer Tools.

  2. A dialog box prompting you to Select a server and to Select a Database is displayed. Select your SQL Server and SQL Server database. Click OK.

  3. If the database has not been registered as a team solution, the Database Registration wizard appears.

  4. On the Registration page, enter your team solution name, an optional description, and the location of your Web URL (this should be the name and location of a FrontPage Web, for example, "http://<YourServer>/WFTracker"). Accept the defaults, or type your own data.

  5. Click Next, and then click Finish.

Once processing is complete, the solution is opened in the Access Workflow Designer.

For information on where to go from here, see Developing a Team Solution.