Unsafe Expressions (1 Viewer)

[daveUK]

Hi,

I'm using Windows 2K SP4 and have just installed Office 2003. Everytime I open Access I get a message asking if I want to block unsafe expressions (presumably macros). How can I turn this off?

BTW I've downloaded all of the security updates, which are recommended by MS.

Thanks

 

[daveUK]

It's OK, I've managed to get this sorted.

For anyone else with the problem, you need to select Tools - Macro - Security and set the level to Low.

Bloody annoying if you ask me as most databases will have some type of macros.

 

[Autoeng]

There is more problems to come. I just switched and hate it. Luckily once you set the security to low it works for all db's.

 

[Ron_dK]

Bloody annoying if you ask me as most databases will have some type of macros.

That's why the majority of the Access guru's on this forum wants you to use VB in stead of macro's !!!


..

 

[ghudson]

You get the warnings if the Access 2003 db has macros and/or visual basic code. Search around for there are ways to handle it so that it is a non issue for your users.

 

[vbc22]

It's OK, I've managed to get this sorted.

For anyone else with the problem, you need to select Tools - Macro - Security and set the level to Low.

Bloody annoying if you ask me as most databases will have some type of macros.

Where is this security option? I can't find it. And it's really annoying to open databases with that prompt.

Can you let me know?

Regards.

 

[vbc22]

Ok, I found it.

I had to first put the Security button on the menu toolbar before I could access that bloody Security dialog window.

1. On menu toolbar, right-click to choose Customize.
2. Choose Tools from Categories list and scroll to the bottom of the Commands list to drag Security to the menu toolbar.
3. Click on the newly added button and select LOW security.

 

[Autoeng]

Not that difficult. From the Menu bar select Tools - Macro - Security.