Macro Security Level

[ions]

Why does Excel have an emphasis on macro security level (high, medium, low) but Access doesn't? Both use VBA.

Also when Excel loads it always requests a virus scan but when Access loads it just loads? How come?

On another note why doesn't Access have a Macro Recorder?

Thanks.

 

[gemma-the-husky]

1. access 2K on DOES have the security levels you note - tools/macro/security or something similar. It warns you when you open a DBS that it contains code or macros and confirms you wish to open it.

2. I dont use Macros, I prefer code, but I think an Access Macro is different in concept from an Excel macro, as it effectively exceutes a series of pre-defined commands eg queries each affecting a subset of data, which isnt quite what an Excel Macro does. I am sure someone will have a much clearer definition and explanation.

 

[ions]

Excel Macros are all code. There is no Macro grid it all goes to VBA.

Access doesn't have the Macro security thing.

Access doesn't ask me about macro safety when I first open it up. I don't need a digital signiture in Access. But I do in Excel (at security level 2 or 3)

Why would security be so tight in Excel and not in Access when they both use VBA?

 

[Rickster57]

security

GEMMA is corect. If (access 2003 or greater, or should I say newer....don't know about 2000 since it's been a while since I used it...) an Access db uses macros and the user has his/her macro security setting in Access set to medium a form will pop up asking if you want to enable macros.
If set to high unsigned macros are automatically disabled. I see this on several client's computers.

Hope this helps.