Access 2003 Warning Messages 3

[dpdoug]

In Access 2003 I am using the ADP running on top of a SQL Server database. I want to be able to launch it using the scheduler at a certain time.

The problem is when it first tries to open up there are 2 warning dialogs that you can only get rid of if you manually click the buttons OK and Open.

How can I turn this off so that Access can run unattended?

Thanks.

 

[Bullsandbears123]

Have you tried using the send Key command to try to click it?

 

[dpdoug]

No I haven't. But I suppose it would have to be triggered in the AutoExec macro. But would that be soon enough to get press those buttons?

How would you implement this?

 

[BuGlen]

You can disable these warning messages by setting the macro security to low in Access. Macro security is new to Access in the 2003 version.

From the Tools menu, goto Macro and then Security. Set the security to Low and it will behave as it did in Access 2002 and earlier.

Hope this helps.

Glen

VB.Net student.

 

[psemianonymous]

I think the Jet4 SP8 update will fix this. It's an available update from windowsupdate.com

 

[BuGlen]

The Jet update will only fix one of the 2 warnings that are displayed. The macro security message will still be displayed even with the update.

As an alternative method, you could leave the security setting alone and use SelfCert to create digital certificates for your Access apps. I haven't used this method, so I can't really say how reliable it is.

Glen

VB.Net student.

 

[dpdoug]

Setting the macro security to low worked to turn BOTH security warning messages off.

Thank you very much!!!

 

[JeroenNL]

I have a related problem. I set the Macro Security to low and this works perfectly for all users except one! He has to set it to low each day again. Does anybody know how to solve that one?

Bye,
Jeroen

A 3D editor project

http://www.delgine.com

 

[jwhjr]

JeroenNL,
I had the same issue, you can get around this by changing the registry setting directly. The setting is here:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Security

Then set the value of the Level Key to 1.

Hope this helps,
JR

 

[JeroenNL]

Hey, thanks very much for that comment, it's good to know where to look in the registry. Now I only hope I am allowed to change this setting. You see, all users work on a server. They login on that server with their own account and the work with the application on that server. I guess I have to alter the registry setting for this single user that is having a problem, correct?

Bye,
Jeroen

A 3D editor project

http://www.delgine.com

 

[scking]

It seems this string is a good place to post this security issue since it is right along these lines. I distribute Access 2000 applications to the military any requiring them to set their macro security level to 'Low' is very presumptious. I want to digitally sign an Access 2000 application so the macro security will not display the warnings. I know that Office 2000 products like Excel and Word have the capability to sign the VBA macros but Access 2000 doesn't have the same menus and doesn't contain anything about digital signatures in the help files. Can anyone tell me if it is possible to sign an Access 2000 application, either through the menu or in VBA?



---------------------
scking@arinc.com
---------------------

 

[BuGlen]

You can add a digital certificate to an Access 2000 (2002,2003) project, but you will need to purchase a public certificate from a company like VeriSign for distribution.

Personal certificates can be done using the selfcert.exe, but it will need to be run on every workstation on which the application is installed. Also, you will have to attach the certificate to the project on each workstation manually as well.

As you can see, there is no easy way around the security (for good reason). If your projects are your business, then I would suggest the commercial route of purchasing and using the public certificates.

Hope this helps.

- Glen

Know thy data.

 

[scking]

Glen,

I've done quite a bit of research on the issue. There are actually three ways around this. Set the macro security to 'Low', do self-certification on every workstation, and digitally signing the application. Since it goes to hundreds of users and most are not computer savvy, asking them to do self-certification is out of the question. According to Microsoft, you can digitally sign Office 2000 applications. That statement is ambiguous because some people include Access when talking about Office and some don't. I actually have to purchace Office Professional to get Access included. MY WHOLE PROBLEM is that, while I can open Excel and Word to see the menu Tools/Macros/Security and see how to sign the application, the same capability is NOT found in either Access XP or Access 2000. I've access to all versions from 97 to 2003 and the only version of Access which had the menu item to digitally sign the application is 2003. I've contacted Verisign and they can tell me what certificate to purchase for signing VBA applications but not whether the application can use them. I've contacted Microsoft and they wanted $$$$ to even talk to me even though their documentation does not seem to cover this issue. I've used a Thawte Code Signing certificate for signing an Excel application and it doesn't seem to work. I've looked in the help files and there is nothing about digital signatures in Access 2000. I've checked my third party documentation (3 books) and there is nothing in the index. No one seems to be able to say YES, I've done this and here is how. Any help to resolve this rather technical issue would be appreciated.





---------------------
scking@arinc.com
---------------------