Share via

Main Table Selection Wizard

  • Article

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.

The Main Table Selection wizard walks you through the process of identifying main user tables and defining the permissions for those tables. It is necessary to designate a table as a main table before you can enable row-level permissions for it.

Once you have selected your main tables, the wizard automatically identifies any detail or lookup tables associated with the main table. The main table is displayed under the Tables node in the Object List, and the detail and lookup tables are displayed beneath it.

Launch the Main Table Selection wizard from the Access Workflow Designer. From the Edit menu, point to Insert, and then Main Table. Or, in the Object List, right-click the Tables node and select New Main Table.

The Main Table Selection wizard includes a series of pages for designating a main table.

  • User Tables page is used to identify a user table as a main table. These tables are the tables that contain the primary information for your database and can be used in a workflow process.

  • Row-Level Permissions for Main Tables page is used to specify the main tables for which you would like to enable row-level permissions. Row-level permissions make it possible for users to set different permissions on each row in the main table. Row-level permissions may also be enabled on the Tables pane of the Access Workflow Designer.

For information about finding specific tools and wizards, see Accessing Access Workflow Designer Tools.