Can I block unsafe expressions from MS Access when my application opens, so
user does not get warning "Unsafe expressions are not blocked......"

Thanks a lot in advance!

Go to Tools -> Macro -> Security and set to Low.

This will keep warnings from being shown, but is a vulnerability.

You can also publish your access project, and trust yourself as publisher in
security, but I'm not sure how to accomplish this, I've never done it before.
That would be the ideal way to go, but a bit more work.

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill


"chris" wrote:

> Can I block unsafe expressions from MS Access when my application opens, so
> user does not get warning "Unsafe expressions are not blocked......"
>
> Thanks a lot in advance!

Sorry, I didn't see your post below, which indicates that you already know
how to manually set the macro security.

I'm not sure there's a way to do this through code, it would seem as though
that might defeat the purpose of it, nor am I aware of how to open that
security window via code. But this is hardly my area of expertise.

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill


"dymondjack" wrote:

> Go to Tools -> Macro -> Security and set to Low.
>
> This will keep warnings from being shown, but is a vulnerability.
>
> You can also publish your access project, and trust yourself as publisher in
> security, but I'm not sure how to accomplish this, I've never done it before.
> That would be the ideal way to go, but a bit more work.
>
> --
> Jack Leach
> www.tristatemachine.com
>
> - "Success is the ability to go from one failure to another with no loss of
> enthusiasm." - Sir Winston Churchill
>
>
> "chris" wrote:
>
> > Can I block unsafe expressions from MS Access when my application opens, so
> > user does not get warning "Unsafe expressions are not blocked......"
> >
> > Thanks a lot in advance!