After adding a workflow process to a table, you can test the workflow directly from that table in your Access Project or in the SQL Server Enterprise Manager. Even without any script, the workflow states you have designated, along with permissible transitions and actions, will be enforced when you enter data into your table.
Note When you create a workflow process by designating new states rather than using an existing column, the Workflow Process wizard creates a <tablename>StateLookup table that contains a stateID and the actual name you entered for your states. When you view your table, you must enter the integer value of the states (1,2,3, and so on) to test the validation. Or, preferably, you can create a form with a combo box linked to the <tablename>StateLookup, so you can see the state names themselves.
Note You may have to refresh your database to view the new objects added by the Workflow Process wizard.
For information on creating a lookup in Access, see "Create a bound list box, combo box, or drop-down list box that retrieves data from a table or query in an Access project or a data access page" or search on "combo box lookup" in the Access Help.
To test workflow
For example, try to delete a record while it is Active. Unless you have added Delete as a permissible action for this state, you will be notified that this is not a valid action.
Try to change the status of your record from the first state to the last state. Unless you have added transition actions that make this transition possible, you will be notified that this is not a valid action.
If workflow is not performing as expected, return to your workflow diagram and ensure you have saved your workflow and refreshed the database. Also make sure you have created the necessary transitions and added appropriate actions for your states.
For more information, see the workflow section in the Troubleshooting topic.