How to change the macro security level in Microsoft Access

To set the security level in Word, Excel, Outlook, or PowerPoint
   1. On the Tools menu, point to Macro, and then click Macro.   2. Click the Security Level tab and select a security level.
If you can’t find it in the menu, then try this registry hack.
Microsoft Office Access 2002 (aka OfficeXP)[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\10.0\Access\Security]“Level”=dword:00000001
Microsoft Office Access 2003[HKEY_LOCAL_MACHINE\Software\Microsoft\Office\11.0\Access\Security]“Level”=dword:00000001
Microsoft [...]

No Comments

Why does Access display these security warnings?

How do I change the macro security level in Access?

On the Tools menu, point to Macro, and then click Security. If you do not see the Macro menu item under the Tools menu, or the Security menu item under the Macro menu, click the arrows at the bottom of a drop-down menu to display the [...]

No Comments

Microsoft Access Query Tips and Techniques

Query Types
Microsoft Access supports many types of queries. Here is a description of the major categories:

Select QueriesRetrieve records or summaries (totals) across records. Also includes cross-tabulations.
Make Table QueriesSimilar to Select queries but results are placed in a new table.
Append QueriesSimilar to Select queries but results are added to an existing table.
Update QueriesModify data in the [...]

No Comments