Creating Data Access Pages

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.

After you have enabled workflow on your database and have the tables and views required for data entry, you can create the data access pages using the Page editor in Microsoft® Access.

To create a new data access page

1. Open your Access Data Project in Access.

2. In the Objects list, click Pages.

3. Double-click Create Data Access Page By Using Wizard.

4. From the Tables/Queries list, scroll down to the Views, and select the view for the table that will be accessed using the Web page.

5. From the Available Fields list, add the columns you want to display on the Web page to the Selected Fields list. Click Next.

   Note   For the workflow toolbar to function, you must include the column that stores the modStateID.

6. Click Next to accept the default grouping levels.

7. Click Next to accept the default sort order by.

8. Give your Web page a title. Leave the option selected to modify the page's design. Click Finish.

9. With the data access page open in design view, open the View menu, and click Properties.

10. Select the Data tab.

11. In the UniqueTable property, select the name of the base table associated with the view.

12. Save your Web page to the site you designated when you first enabled workflow on the database.

See Also

Creating User Interfaces | Creating Webs Using FrontPage | Using the Office Developer Workflow Toolbar Control | Adding the Workflow Toolbar control to Data Access Pages | Adding Script to Data Access Pages Using the Microsoft Script Editor