message pop up for users when database opens

[ecalvert47462]

All,

I am currently working with Access 2007...and have end users that open the database to do their daily entries...upon opening a security warning pops up so the user can then click on Options, then Enable This Content and then ok....

What I'm wanting to do is have a window pop up when the user opens up the database to "remind" them to enable content....

Does anyone know how to do that?



I work where the trust center option can not be used for security reasons.

I say to teach the end user to make a business practice but my manager wants to simplify it for everyone...lol

Thanks,
Eric

[June7]

Code won't run because the db is not trusted and Macro Settings is set to Disable all?
You want something more than the automatic 'content has been blocked' message bar?

Try setting a form as default open in the project settings. This form can have a big textbox with big bold text "ENABLE CONTENT NOW"

[pbaldy]

Since code might not be enabled, I'm not sure you can count on a message box appearing. I'm visualizing a startup form that advises the user to enable code. In that form's timer event, you can have code to close that form and open your actual starting form. If/when code is enabled, that form should disappear by itself.

[JeroenMioch]

The warning your getting, is that an "Unknown publisher" warning ?

[rpeare]

What you're getting is a warning because of your macro/scripting security settings. In order to get rid of that warning every time you open the database there are a few things you can do.

1. The most dangerous is to go to: Click Windows Icon in upper right corner>ACCESS OPTIONS (lower right corner)>TRUST CENTER>TRUST CENTER SETTINGS>MACRO SETTINGS>ENABLE ALL MACROS. If your environment is not secure (your users are educated about not opening things automatically and deleting any email with an attachment from a source they don't trust etc) this is not the greatest solution.
2. A more limited option is to do this: Click Windows Icon in upper right corner>ACCESS OPTIONS (lower right corner)>TRUST CENTER>TRUST CENTER SETTINGS>TRUSTED LOCATIONS click ADD A NEW LOCATION and put in the path where the database resides. As long as nobody copies anything malicious in there you should be good.

There are other ways as well (you can set the trust settings on individual databases too) but these are the most basic ways.

[ecalvert47462]

So would this form, that would be a default open, would that be different than the form that I have set up in current database options to appear when it's open? In other words, when the end user opens the database up the main form appears.

[ecalvert47462]

pbaldy...that sounds exactly like what i would want to do..I found the timer settings but haven't quite figured out how to get that to pop up and then disappear on it's own to then go to my startup form.

[pbaldy]

This is untested, but if it's set as the start form and has the right code in the timer event, I think it will work. The code in the timer event would just open the actual start form and close this one. If code hasn't been enabled, this form would stay open because the code wouldn't run. If code is enabled, it should run the code and close itself. I have to run out right now but if you get stuck I'll test it. Don't forget to set a timer interval too (something short would probably be fine).

[Vetgeorge]

pbaldy...that sounds exactly like what i would want to do..I found the timer settings but haven't quite figured out how to get that to pop up and then disappear on it's own to then go to my startup form.

I've done something exactly as you describe, I made a form reminding people about security settings, with an "OK" button (control button). Have the reminder form open when the database is first opened. When they click "OK", it closes.
For the button control, you specify either to close the current form or have your main form open.