Get rid of startup dialog?

[Spitfire]

How do I get rid of the start up dialog? The boxes which pop up and say "Security warning, Unsafe expressions not blocked" and the other that says "warning this document may not be safe blah blah blah".

Thank you for the help

 

[CraigDolphin]

You either need to obtain/create a digital certificate and 'sign' your vba with it, or else change your macro security level to low.

You can buy digital certificates from places like verisign, or you can make your own (there's a digital certificate utility from microsoft that allows you to create your own: see http://msdn2.microsoft.com/en-us/library/aa141471(office.10).aspx for instructions)

If you deal with digital certificates a lot that's the way to go but, as an amateur, I've found them to be a PITA to use and have resorted to reducing macro security as a more viable alternative until the app is finalized and tested to be bulletproof before signing and distributing.

Of course, I should warn you that lowering security is a risky business so don't sue me if you go that path.

 

[Moniker]

Lowering security is only risky if you're using Access apps where you have no idea of their origin. So long as you're using all internal and/or trusted sources, and not just opening random DBs that show up in email, then you're fine.

If you're paranoid, you can always scan DBs and such with a good virus scanner, or you can open Access, change the security level, and then open the DB in question. Otherwise, it's basically a CYA for MS. They can say, "We told you so!" if something gets fubared.

Bottom line: know your DB data sources. Don't just randomly open things.

 

[CraigDolphin]

Otherwise, it's basically a CYA for MS.

Bottom line: ...

Sorry...it's friday afternoon and I couldn't resist

 

[bodylojohn]

I set the macro security to low and I still get the warning.

 

[Moniker]

Is the security level being changed by the DB? Is it a custom dialog within the DB? What runs when the DB starts?

 

[bodylojohn]

Is the security level being changed by the DB? Is it a custom dialog within the DB? What runs when the DB starts?

The security level is set to low and I dont set it anywhere else in my code.

When the DB starts my mainscreen is opened containing only buttons which link to the rest of the program (embedded macro's)

I attached an image of the error message.

 

[Moniker]

Did you follow Craig's suggestion and digitally sign the DB? It's telling you that it cannot determine the authenticity of the DB, and therefore, it cannot be as close to 100% positive as possible that it won't harm the computer.

 

[bodylojohn]

Did you follow Craig's suggestion and digitally sign the DB? It's telling you that it cannot determine the authenticity of the DB, and therefore, it cannot be as close to 100% positive as possible that it won't harm the computer.

Hello,

I tried to sign my db using this link:
http://office.microsoft.com/en-us/access/HA102345621033.aspx

But In still get the message

What else could I be doing wrong?

 

[boblarson]

What Operating System and version of Access are you using?

 

[bodylojohn]

I just installed the app on my own pc (Access 2007 is NOT installed, only 2003) and here I dont get the security warning.

Basically the other user (where the warning appears) en me heve the same configuration.

What to do?

 

[boblarson]

If using Access 2007 add the location to the trusted locations. See here for how:

http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

 

[bodylojohn]

If using Access 2007 add the location to the trusted locations. See here for how:

http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx

Hi Bob,

This thing is realy bugging me LOL.

I added a trusted location and I even got rid of the adobe add in.
I am going nuts out here.

Well...I just hope that you (my heroes) can help me..

 

[bodylojohn]

I just dont get it.

Security level of the macros are set to low so I shouldn't be getting this error message.

HELP ME please...

 

[boblarson]

Just found this - maybe it will help:

http://support.microsoft.com/kb/937999

 

[CraigDolphin]

*sigh* Another layer of botched 'security' crud to wade through. Makes me more determined than ever to never move past WinXP/Office03 before switching to a different OS and eventually another development platform.

 

[Moniker]

Actually, Craig, I think this one is more user error than anything else (no offense meant to the user). He just took something over he's not familiar with, and doesn't know what he's doing in some aspects. Yes, the security is tighter, but it's not something an experienced developer would have any trouble with.

 

[bodylojohn]

Just found this - maybe it will help:

http://support.microsoft.com/kb/937999

That did it...

IT WORKS!!

I do not get a security message anymore.

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

So hopefully they get it fixed so I can install it on a pc where everybody can use it.

But this is great for now..

Thanks guys..

Moniker.. I was a little bit offended because of your comment.
Perhaps it was not your intention but I am just a guy who loves application development in ms access 2007 (later on VB 2005). I know I am not as skilled as some of you guys here but I am learning and thanks to this board I am progressing in my development skills.

Its not a big deal I just hadded to tell you how I feel..

No hard feelings bro...

 

[boblarson]

Glad you got things to work.

 

[skilche1]

Just found this - maybe it will help:

http://support.microsoft.com/kb/937999

Bob,

Can you update this? I am running 2007 and I do not have access to decreasing the macro security level.

Thanks,

Steve