Developing a User Interface for SQL Server

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

You can develop the user interface for your application in any tool that can connect to and use a Microsoft® SQL Server™ database. However, the easiest user interface to integrate with Workflow Designer for SQL Server is a Web site created using Microsoft® Access data access pages. Data access pages also make it possible for you to take advantage of the built-in functionality of the Office Developer Workflow Toolbar control.

Although you can use any Web development program to create your Web-based user interface, many of the procedures later in this documentation assume Access data access pages are used to create the Web site.

If you are using a template to create your workflow application, a Web site is created for you when you use the SQL Server Workflow Template Instantiation wizard. You can use this Web site as the basis of your new application's user interface.

In This Section

• User Interface Considerations
  Design your user interface to use the Workflow Designer's features.
• Row-Level Permissions and the Workflow User Interface
  Create a user interface where each workflow user can define quickly and easily row-level permissions that determine which roles can see items entered by that user.
• Creating User Interfaces
  Make it possible for users to work easily with data in your workflow application by providing a powerful user interface.
• Help Files in Workflow Applications
  Implement help for your application as HTML files on your application's Web site.
• User Information for Workflow Applications
  Maintain security specific to your workflow applications on the server by means of the Workflow Application User Directory
• Using Alternative User Interfaces
  Create a user interface for your workflow application using any tool that provides database access.

Related Sections

• Developing Workflow Applications for SQL Server
  Simplify the task of creating typical workflow applications, such as forms routing/approval, document review/publishing, and issue tracking, by using the workflow engine and specialized workflow modeling tools of the Workflow Designer for SQL Server.
• Workflow Applications Architecture for SQL Server
  Understand how the Workflow Designer for SQL Server and Workflow Services for SQL Server help you build, modify, and add script to workflow applications on a database.
• Planning Workflow Applications for SQL Server
  Review the design considerations for the database schema, security, and other aspects affecting a workflow application.
• Building Workflow Applications for SQL Server
  Build database-driven Web applications that take advantage of integrated row-level security features.
• Setting Up Accounts, Logins, Roles, and Users
  Assign permissions to users through the Workflow Designer that complement the security of Microsoft® Windows® 2000 and Microsoft® SQL Server™.
• Scripting Workflow Events for SQL Server
  Add script to extend the capability and functionality of your workflow process.
• Creating Templates
  Store a complete workflow application in a reusable, transferable template.
• Troubleshooting Workflow Applications for SQL Server
  Find answers that help avoid or resolve the most common errors and issues you might encounter when using Workflow Designer for SQL Server.