Permissions Property (MDB)

Permissions Property (MDB)

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.