|
How to start the secured database?
During installation, “Seven” creates appropriate shortcuts (Medical Database "Seven") in Windows Desktop and All Programs group in order to open the secured application front-end (CodeMD.mde) with the appropriate Workgroup Information File (seven.mdw).
You can recreate those shortcuts in Windows Desktop following the steps below:
| 1. |
Open the Application Folder (usually C:\MDbaseSeven) |
| 2. |
Open the Folder Start application |
| 3. |
Right Click on "Start Seven Frond End" Icon |
| 6. |
The shortcut is recreated in Desktop. |
The database can also be opened manually.
| 1. |
Start Medical Database Seven. |
| 2. |
On the Tools menu, point to Security, and then click Workgroup Administrator. |
| 3. |
In the Workgroup Administrator dialog box, click Join. |
| 4. |
Type the path and name of the workgroup information file defining the Microsoft Access workgroup you wish to join (usually C:\MDbaseSeven\Seven.mdw), and then click OK, or click Browse and then use the Select Workgroup Information File dialog box to locate the workgroup information file. The next time you run Microsoft Access, it uses the user and group accounts and passwords stored in the workgroup information file for the workgroup you joined. |
How to change Default User permissions in Workgroup Information File:
| 1. |
Start Medical Database Seven. |
| 2. |
Logon as Administrator (default director). |
| 3. |
The control Panel opens. Click on Change Permissions (or later inside the application open the Tools menu, point to Security, and then click User and Group Permissions . |
| 4. |
On the Users page, select a User Name ... |
You can manually change database and object permissions for user and group accounts in a workgroup. Permissions are granted to groups and users to regulate how they are allowed to work with each table, query, form, report, and macro in a database.
Permission Types
Each user has access to nine types of permission for objects in a database. The following table describes the nine types of permission, and what each type enables a user to do.
|
Permission Type
|
Permits a user to
|
Involve
|
|
Open/Run
|
Open a database, form, or report. Run a macro.
|
Databases, forms, reports, and macros.
|
|
Open Exclusive
|
Open a database on a network, while ensuring that others cannot open the database while the first user has it open.
|
Tables, queries, forms, reports, macros, and modules.
|
|
Read Design
|
View the design of objects. No changes to the design are allowed.
|
Tables, queries, forms, reports, macros, and modules.
|
|
Modify Design
|
Change the design of objects and delete objects.
|
Tables, queries, forms, reports, macros, and modules.
|
|
Administer
|
Set database passwords, replicate databases, and change startup properties. Have full access to objects and data, and assign permissions for objects.
|
Databases, tables, queries, forms, reports, macros, and modules.
|
|
Read Data
|
View data, but not table designs or query designs.
|
Tables and queries.
|
|
Update Data
|
View and edit data, but not insert or delete data.
|
Tables and queries.
|
|
Insert Data
|
View and insert data, but not change or delete data.
|
Tables and queries.
|
|
Delete Data
|
View and delete data, but not change or insert data.
|
Tables and queries.
|
Useful links
Frequently asked questions about Access 2003 security warnings
|
