Access 2003 - form property not working with 'medium' macro security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This seems allied to Peter Kaufman's difficulty (see post of March 6 2004) but as he got no answer I've made a new thread

I've converted a database to Access 2003. A form includes a property defined in VB (get and set)

If running with macro security level set to low, everything works fine

However, if I change to macro security level medium (and reply Open to the warning message on opening the mdb), as soon as I attempt to open the form I get a prompt asking for the property! I thought macro security = medium only issued a warning, not changed behaviour of the app!

I have Jet4 SP8 installed, and have 'sandboxing' turned ON for both macro security setting
(ie registry value = 3, as described in KB294698.) Running on Windows XP SP1

This is really bugging me! Can anyone help
The form is running some form_load code which attempts to set the property, but the same thing happens even when I comment out the form_load reference

Thanks... DesB
 
Hi,

You use an unsafe VBA function in that property ? See
http://support.microsoft.com/?id=239482


Hoping it may help,
Vanderghast, Access MVP


DesB said:
This seems allied to Peter Kaufman's difficulty (see post of March 6 2004)
Click to expand...
but as he got no answer I've made a new thread.
I've converted a database to Access 2003. A form includes a property defined in VB (get and set).

If running with macro security level set to low, everything works fine.

However, if I change to macro security level medium (and reply Open to the
Click to expand...
warning message on opening the mdb), as soon as I attempt to open the form I
get a prompt asking for the property! I thought macro security = medium
only issued a warning, not changed behaviour of the app!?
I have Jet4 SP8 installed, and have 'sandboxing' turned ON for both macro security settings
(ie registry value = 3, as described in KB294698.) Running on Windows XP SP1.

This is really bugging me! Can anyone help?
The form is running some form_load code which attempts to set the
Click to expand...
property, but the same thing happens even when I comment out the form_load
reference.
 
Back
Top