Microsoft Access defines four types of Container objects in addition to those defined by the Microsoft Jet database engine. These include the Forms, Reports, Scripts, or Modules Container objects. Individual Form, Report, Script and Module Document objects belong to the Documents collections of these Container objects. For these Container and Document objects, you can also set the Permissions property to the following constants.
Constant | User or group can |
---|---|
acSecFrmRptReadDef | Open the form or report in Design view but not make any changes. |
acSecFrmRptWriteDef | Modify or delete the form or report in Design view. |
acSecFrmRptExecute | Open the form in Form view or Datasheet view; print or open the report in Sample Preview or Print Preview. |
acSecMacReadDef | Open the Macro window and view a macro without making changes. |
acSecMacWriteDef | Modify or delete the macro in the Macro window. |
acSecModReadDef | Open the module but not make any changes. |
acSecModWriteDef | Modify or delete the contents of a module. |
acSecMacExecute | Run the macro. |
Note acSecModReadDef and acSecModWriteDef are included for backward compatibility only. Since Module access is now controlled by the Protection property in the Visual Basic envronment, these constants are no longer valid parameters in Microsoft Access2000.