1. Open microsoft access database template while holding SHIFT key (or select file and press ENTER while holding SHIFT key)
2. File> Access Options> Current Database:
Choose Display Form: Navigation Form
Disable Use Access Special Keys
Disable Display Navigation Pane
Disable Allow Full Menus
Disable Allow Default Shortcut Menu
3. Insert usernames in table "tblUser" (For additional information see "How to give administrator privileges to user")
4. Click on "Enable Content" at MS Access Message Bar
5. Re-open database
That is it. Your database will now open in a separate window.
Still having problems? Please watch instructional video.
Hold down the SHIFT key on your keyboard while opening the database.
1. Open microsoft access database template in full view (hold down SHIFT key when opening)
2. Open table "tblUser"
3. Enter user name in field "UserName" and PC user name in "UserLogin" filed
4. Save table and re-open database
5. Your PC username should be displayed as User in bottom right corner, also tabs "AddSubject" and "AddDocument" are now available
You can also watch video on how to do this.
There are more than few ways to view your PC username, these are two simple ones:
1. In C:\Users\ there is a folder named same as PC username (something like C:\Users\your-name)
1. Type "cmd" in Start window to run Command Prompt
2. Type "echo %username%"
3. Your computer login name will be displayed
To open microsoft access database template in Navigation form you have to set MS Access options to open specific form, in this case Navigation form and disable following options:
File> Options> Current Database> Display Form: choose Navigation form; disable "Use Access Special Keys", "Display navigation Pane", "Allow Full Menus" and "Allow Default Shortcuts Menu"
There are 2 types of users in Access Document Manager:
1. Admin- this type of user have full access and can add new Documents and Subjects from tabs “Add Subject” and “Add Document”.
2. User- this type of user have limited access, tabs “Add Subject” and “Add Document” are grayed and are not accessible.
You can change type of user following this procedure (as shown in video):
1. Select database, hold SHIFT key while pressing ENTER
2. Open table “tblUser”
3. Change UserLogin field to your current logged user on your PC
(if you don’t know your user name, open CMD and type “echo %username%”, it will be displayed under this line)
4. Change UserSecurity field to “Admin”
5. Save changes and re-open the database
Now you have full access to the database.
Notice that if you type name that is not currently logged user in UserLogin field, database will log you as Guest and message “Your computer User Name is not set as Application User. You will be logged on as a Guest.” will appear.