access

Disable macro security in Access 2007

Access 2007 disables macros by default, and then you have to go through the new "Trust Centre" to find it. Here's the simple procedure to switch it off.

Printer Icon on Access 2003 task bar says (no Printer)

It seems that Access 2003 has a bug. Rarely, if the default printer is a PCL printer, this version of Access will simply refuse to recognise any printers - and they will not appear in the "Print" dialog window. There are three solutions that help.

  1. Change the default printer to some other installed printer. Then change the printer back to the PCL one within Access 2003. This worked for me but was not a satisfactory solution.
  2. Find Postscript drivers for the printer in question, install them and set this as the Default Printer. This is what worked for me.
  3. Installing the latest printer driver on the network printer. (From comments below).
  4. I read that Office 2003 Service Pack 1 resolves this problem, although I have not confirmed this yet as fix 2 worked for me. Update - A commenter below indicates that SP2 (and thereby SP1) does not fix it.

 

Access 2003: Unsafe Expressions are not blocked

When you open an Access 2003 database, you get 3 annoying errors.

  • Security Warning: Unsafe expressions are not blocked Do you want to block unsafe expressions?
  • A Microsoft Jet 4.0 Service Pack warning
  • Then another "Security Warning"

To fix this, you can lower your Access security settings manually, or simply use this registry entry to do it for you.

The whole error is:-

To block unsafe expression Microsoft Jet 4.0 Service Pack 8 or later must be installed. To get the latest version of Jet 4.0 go to http://windowsupdate.microsoft.com
Microsoft Jet 4.0 Service Pack 8 or later must be installed to block unsafe expressions without affecting common functionality.
The latest Microsoft Jet 4.0 service pack is available from Windows Update.
To block unsafe expressions, see the About Microsoft Jet Expression Service sandbox mode Help topic, which is available from the link at the bottom of this topic.
If the service pack is not applied:
Wizards and builders may not start.
Switchboards created by Switchboard Manager will fail.
The RunCode macro action for calling a Visual Basic for Applications (VBA) procedure will fail.
Event handlers that call VBA procedures will fail.
VBA procedures called from a property sheet or used in a SQL statement will fail. 
Filtering on a hyperlink field will fail. 
Some VBA functions called from a property sheet or SQL statement will fail.
More information about this error message online.

The security warning:-

"This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?"

Outlook 2003 Unblock Attachments (set for all Access filetypes)

Just unzip this file (modify if you wish) and run unblock Access attachments in Outlook 2003.

To modify it, simply open in Notepad, and change the "Level1Remove" line to add other file extensions. Keep them in semi-colon delimited format.

_____________________________________________________
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Security]
"Level"=dword:00000003
"UseCRLChasing"=dword:00000001
"Level1Remove"="mdb;mda;mde" 

Google

blog categories