Microsoft® Access® 2010 Inside Out

Checking SharePoint User Permission Group Levels

In the Back Office Software System sample web database, we verify the assigned group level for a user when the user navigates to the main web startup form in the browser. We then display one of two possible web forms based on the user’s assigned group. We’ll demonstrate how this functionality works in the browser in Chapter 22, but for now, we’ll show you the macro logic and conditional expressions we use to check the Microsoft SharePoint group level.

Close any objects you might have open, right-click the web form called frmLoading in the Navigation pane, hold down the Shift key, and then click Layout view from the shortcut menu. Note that you must hold down the Shift key while opening this web form ...