How to Switch Profiles in Access 2007
- 1). Right-click on the desktop and point the cursor to "New." Select the option for "Shortcut."
- 2). Type " "C\Program Files\Microsoft Office\Office12\msaccess.exe" " in the "Type the location of the item" text box. Place a quotation mark at the beginning and end of the path.
- 3). Press the space bar key and type "/[user]." The path should look like " "C:\Program Files\Microsoft Office\Office12\msaccess.exe" /[user]."
- 4). Click the "Next" button.
- 5). Type a name for the shortcut in the "Type a name for this shortcut" text box. Click the "Finish" button to complete the process.
- 6). Double-click the shortcut to start Microsoft Access with the specified user.
Source...