runtime security

[Johnny]

I've distributed my app with the Access 2K3 runtime, when
it opens up, I get 3 dialog boxes about security warnings
(jet, sandbox, do you still want to open this project..)

what I neeed to do is lower the macro security setting.

How is this done in the runtime version on a end-users
workstation ?

Thanks
J.

 

['69 Camaro]

Hi, Johnny.

You can change the Windows Registry manually, or you can write VBA code to
open the Macro Security dialog window for the user to make the change
manually in the Access runtime application. An explanation of both methods,
including source code, in both English and Spanish, to access the built-in
menu, can be found here:

http://www.Access.QBuilt.com/html/vba.html#SetMacroSecLvl

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Jeff Conrad]

Welcome to Access 2003! Here is some info on this subject:
(Watch out for any possible line wrapping on these links)

You can to go Tools, Macro, Security and set it to low.
If the security item isn't on that menu, you may need to reset your menubar. See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;833219&Product=acc2003

You can also manually add the following Registry keys:
Set registry as follows:

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001

If these are just for your use, you can create a self cert on your computer
and digitally sign your databases. More info at:
http://www.microsoft.com/resources/documentation/office/2003/all/reskit/en-us/seca02.mspx

Other link to see:
http://office.microsoft.com/assista...ID=CH010411421033&CTT=4&Origin=CH010411391033

Frequently asked questions about Access security warnings:
http://office.microsoft.com/assista...ID=HA011225981033&CTT=4&Origin=CH010411391033

Another link on the subject:
http://www.access.qbuilt.com/html/vba.html#SetMacroSecLvl

 

['69 Camaro]

Hi, Jeff.

Thanks for adding lots of good info on how to get rid of these annoying
messages that most Access developers just aren't used to seeing. However,
one of the items of advice you included:

You can to go Tools, Macro, Security and set it to low.
If the security item isn't on that menu, you may need to reset your menubar. See:

http://support.microsoft.com/default.aspx?scid=kb;en-us;833219&Product=acc2003

.... doesn't apply to the Access Runtime version, which is what the original
poster was having a problem with. The built-in menu for the Runtime version
doesn't include the Tools menu, and the Runtime version is not capable of
database design changes, including menu and toolbar changes.

The quickie solution is to either provide a VBA procedure that opens up the
Security dialog window in the Runtime version so that the user can manually
set the Macro Security settings to low, or to manually make these changes in
the computer's Windows Registry. These quickie solutions, including source
code in English and Spanish, are provided on the Web page at the very bottom
of your list:

http://www.Access.QBuilt.com/html/vba.html#SetMacroSecLvl


The better, long-term solution is to create a digital certificate so that
users can keep their Macro Security settings at a higher level without
having the annoying messages popping up every time they run an Access
database application. And you've provided links to lots of good info on
this!

Thanks!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Jeff Conrad]

Hi Gunny,

You're correct of course on the runtime version not having the Tools menu. This is my generic
copy/paste response message for any NG posts on this particular subject. I probably should have
qualified the first statement with a "This particular item would not apply in your case." Thanks for
the assist.

And of course I include your link in my NG response:

http://www.Access.QBuilt.com/html/vba.html#SetMacroSecLvl

I only learn from the best!
;-)

 

['69 Camaro]

Hi, Jeff.

I only learn from the best!
;-)

LOL! Flattery will get you everywhere! ;-)

Actually, learning from the best has been my own plan of attack for learning
everything I can about computers and how businesses can use them most
effectively and efficiently. It saves a lot of time that would otherwise be
wasted in trial and error or just reinventing the wheel. I've had the good
fortune to work with some fantastic computer pros in the last several years,
and I've absorbed years worth of knowledge each year, so they've helped
accelerate my learning curve considerably.

How's the tutoring coming along? Got many students lined up now that people
know your expertise is available for hire?

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Jeff Conrad]

Hey Gunny,

LOL! Flattery will get you everywhere! ;-)

Nothing like some good ol' fashioned "suck-up" grease for the wheel.

Actually, learning from the best has been my own plan of attack for learning
everything I can about computers and how businesses can use them most
effectively and efficiently. It saves a lot of time that would otherwise be
wasted in trial and error or just reinventing the wheel. I've had the good
fortune to work with some fantastic computer pros in the last several years,
and I've absorbed years worth of knowledge each year, so they've helped
accelerate my learning curve considerably.

I wish I had the same good fortune.
I'm mostly self-taught on just about everything, but learn very quickly. I was brought to our main
office after managing locations to work on one thing (and only one thing) which was to set up a
sophisticated database program for all our store locations. I eventually became responsible for all
things "technical" concerning not only all the store locations, but the office as well! I also
traveled to each location to do the following: set up new computers, installed database and
spreadsheet programs I created, set up e-mail and VPN connections, created training materials, set
up and installed new POS systems, and conducted training classes with all the store management. And
that was all in a year and a half!
Geeeez, can you say "Job Growth?!"

How's the tutoring coming along? Got many students lined up now that people
know your expertise is available for hire?

You noticed that?
Not quite what I expected. Thought it would be a student, but this is much more complex and for a
county office. Might have to have some professional assistance with this (already set in motion).
You might even see some NG posts about it.

I must say this has got me thinking about the local community college though. Humm....

 

['69 Camaro]

Hi, Jeff.

Geeeez, can you say "Job Growth?!"

Can you also say "job security"?!! You are quite valuable to your company,
since it would likely take more than one person to do your job as well as
you do it in all of your areas of responsibility. And if you left, it would
take quite some time for your company to train the "new guys" to get them up
to your level of expertise, especially if none of the other employees are
available (or have the expertise) to train these new guys.

You noticed that?
Not quite what I expected. Thought it would be a student, but this is much more complex
and for a county office.

Make sure that you have "group rates" applied per student, with a minimum
number of students for each session. If you have a rate for tutoring a
single student, then that rate should be multiplied by a certain number for
tutoring multiple students, because it's more work on your part.

I must say this has got me thinking about the local community college

though. Humm....

Teaching at community colleges provides an excellent opportunity to network
while showing off your skills and expertise to interested members of the
local community. Having a good "network" will always be to your advantage
when looking for job opportunities, especially when unexpected events arise
concerning "continued employment."

Good luck!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Jeff Conrad]

Hi Gunny,

Can you also say "job security"?!! You are quite valuable to your company,
since it would likely take more than one person to do your job as well as
you do it in all of your areas of responsibility. And if you left, it would
take quite some time for your company to train the "new guys" to get them up
to your level of expertise, especially if none of the other employees are
available (or have the expertise) to train these new guys.

<<shaking head>>
Job security? Well I **suppose**.

The floor fell out a couple of years ago. In a nut shell they did too much too fast and it caught up
with them. All our locations in other states are now gone and only two close by here remain. An
office staff here of close to 25 almost all gone. Only people remaining are the owner, myself, and
an HR/Payroll person. Lots of empty office space. Owner's wife does reception duties for free. I
wear many hats now. So, yes, I'm quite valuable to the company and for sure all my knowledge left
them with little choice but to keep me. I am very grateful for that of course, but it was very
depressing to see most of all my hard work come back in boxes.

Training "new guys"?
What new guys?

So:
Job Security? - Sort of
Company could completely fold any minute? - An every day fear for me
Job Future? - Zip, nada
19 years with the same organization and now no possible future opportunities? - Yep

Make sure that you have "group rates" applied per student, with a minimum
number of students for each session. If you have a rate for tutoring a
single student, then that rate should be multiplied by a certain number for
tutoring multiple students, because it's more work on your part.

That's a very valuable concern I had not thought of.
Thanks for that.

Teaching at community colleges provides an excellent opportunity to network
while showing off your skills and expertise to interested members of the
local community. Having a good "network" will always be to your advantage
when looking for job opportunities, especially when unexpected events arise
concerning "continued employment."

Humm.....something tells me this has already been on my mind for a while...
;-)