Macro Security Settings in Microsoft® Access® 2003
Get to know more about macro security settings in Microsoft Access 2003
Microsoft Access is an application suite from Microsoft Corporation which is used to generate modest as well as as multifaceted database solutions. It is a pseudo-relational database management system which conglomerates the relational Microsoft Jet Database Engine and software-development tools. Microsoft Jet Database Engine included in Microsoft Access 2003 is facilitated with a graphical user interface and has got the ability to store data in its own format. It also allows you to import or link unswervingly to data stowed in other applications and databases. This feature of Access 2003 permits you to create queries, tables, forms and reports, and connect them together with macros. The main assistance of Access is its relative compatibility with structured query language (SQL). The queries could be viewed graphically or edited as SQL statements, which could be used directly in Macros and VBA Modules to handle Access tables.
Here are the details of macro security settings in Microsoft Access 2003:
- Macro Security Settings in Microsoft Access 2003
- Importance of Macro Settings
- Macro Security Settings Level in Microsoft Access 2003
Macro Security Settings in Microsoft Access 2003
Macro security settings in Microsoft Access 2003 has been employed to organize the activation of executable code entrenched within a template, workbook, presentation, document or Project plan. Macro security settings also consolidate the objects connected to these storage files through an OLE link or Dynamic Data Exchange (DDE) connection. Macro security setting can be managed by administrators or the users in an organization with the help of Custom Installation Wizard, Group Policy snap-in, Custom Maintenance Wizard or Office Profile Wizard.
Importance of Macro Settings
The startup options for files loaded into Microsoft Access 2003 application depend on the setting of macro security. It runs the signed executables inevitably when trusted and also blocks the executables, except those in a trusted location when aligned in specific level. In the low macro security level, all executables are run without any security precautions. The medium macro security level runs executables only after user authorization.
Macro security settings for Microsoft Access 2003 can be set to High, Medium, or Low, through the Security dialog box of the user interface. The security dialog box can be attained by clicking 'Macro' option on the 'Tools' menu and then selecting the 'Security' option. You must select 'High' and the 'Medium' macro security level only if it is indispensible. If you set the security level to 'Low', it allows a macro or other executable file to run without the awareness or endorsement of the user.