By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,313 Members | 2,725 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,313 IT Pros & Developers. It's quick & easy.

Access 2003 macro security

P: n/a
Last week I posted as follows, but no-one responded:
" I have security level 'Medium' and expression blocking set. If I set
security to 'Low', I get a dialog box which asks if I want to enable
expression evaluation. Irrespective of whether I respond 'Yes' or 'No', the
security level now shows as 'Low' and databases open thereafter without any
warning dialogs. The only operational difference is that I'm prompted to
restart Access if I choose 'Yes'. So what IS Low-level macro security?? Does
it exist in 2 flavours -- with and without expression blocking?? And if so,
how does Low with expression blocking differ from Medium??"

A little more investigation shows that it IS possible to set macro security
level to Low
whilst maintaining unsafe expression blocking. This seems a reasonable
compromise for
someone developing a small database for their own use: no irritating dialog
boxes to
dismiss when opening the database, but warnings when unsafe expressions are
used.
Mind you, #Name? is hardly an explicit warning to check your macro security
settings.

Dave

--
************************************************** **********************
Dave Stone e-mail: D.*****@ed.ac.uk
Computing Services Telephone: +44 131-650-3314
University of Edinburgh Internal ext: 503314
Main Library, George Square FAX: 0131-650-3308
Edinburgh EH8 9LJ
************************************************** **********************
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.