Security Warning

[Guest]

After installing Office 2003 Professional, my old Access database files open
with a Security Warning that says "This file may not be safe if it contains
code that was intended to harm your computer. Do you want to open this file
or cancel the operation?" This also happens when opening new database files
generated in the 2003 version. The old files were compacted and converted
properly, and I have reinstalled Access 2003, still getting the Security
Warnings. What can be done about it?

 

[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/?id=833219

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

More info here:
How to configure Jet 4.0 to prevent unsafe functions from running in Access 2003
http://support.microsoft.com/default.aspx?kbid=294698

Still more info here:
http://www.fmsinc.com/free/tips.html#accesstip19

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

An online course
http://office.microsoft.com/training/training.aspx?AssetID=RC011461801033

 

[TC]

Welcome to Access 2003! Here is some info on this subject:

(snip)

Puhleeze folks: add the all-round easiest option: start the database
via a script file which suppresses macro security for that single run,
without affecting anything else. Eg. in VBScript:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' low.
o.opencurrentdatabase "full path to your database"
o.visible=true
o.usercontrol=true
set o=nothing

Cheers,
TC

 

[Jeff Conrad]

Hi TC,

Actually I have your information saved in another group of
similar posts. That group deals with specifically avoiding
the security prompt. I did not post that particular group
message here since I thought it be a good idea for Kathie
to read up on the subject first.

Don't worry, I have it (and have posted your info before).

 

[TC]

Thanks Jeff. I just feel that certificates & registry changes are too
hard for many people to handle. And setting macro security low for the
whole PC, is imprudent advice, IMO, since it affects every other
application. The approach that I suggest might not work in certain
cases (eg. if scripting languages have been disabled), but it is the
easiest & most effective approach to try initially, IMO.

Cheers,
TC

 

[Guest]

Thank you for going to all this trouble -- please understand I am not a
software programmer, nor do I understand most of what you wrote. I do
understand the setting to low security under Tools, but this is not available
after my installation and reinstallation. I have been using Access since it
was first written and have never had trouble like this upgrading from one
version to another - never. This is just too frustrating for words. If you
can think of anything else I can do, please write back. Thank you. Kathie

 

[Guest]

Thank you, TC -- I understand your simple answer but know only a little about
VB -- please, where would you write this code? As I told Jeff, I have used
Access since it was first written and have upgraded with every new version.
Never have I had a problem such as this -- has MS gone crazy and forgotten
about its every-day users? Is it now a program just for programmers? How
frustrating. Thanks again. Kathie

 

[Jeff Conrad]

Hi Kathie,

Did you go through all the links I provided?
The links provide very specific detail about how to avoid the security prompts.

I do not quite understand this statement you said:
"I do understand the setting to low security under Tools,
but this is not available after my installation and reinstallation."

What *exactly* do you mean by that?

If you mean you do not have that option on the Tools menu try
reading this link which I provided last time:
If the security item isn't on that menu, you may need to reset your menubar. See:
http://support.microsoft.com/?id=833219

 

[TC]

Hi Kathie

1. Open Notepad or a similar "plain text" editor.

2. Type in the code that I showed in my previous post:

dim o
set o=createobject ("Access.Application")
o.automationsecurity=1 ' low.
o.opencurrentdatabase "full path to your database"
o.visible=true
o.usercontrol=true
set o=nothing

(Type one statement per line. Note that the 'o's are letters, not
digit zeros. Be sure to replace "full path to your database" with the
full path to your database(!) - eg. "C:/windows/desktop/mydb.mdb".)

3. Save the file to your desktop. Give it any name you want, but be
sure that it ends with a .bat (not .txt) extension.

Now you can start your database by double-clicking the .bat file. The
macro security warnings should not appear.

There are certain cases where this might *not* work, eg. if a virus
scanner interferes with starting the batch file. But it is so easy to
try, that you should give it a go.

Good luck,
TC

 

[grep]

As a .bat file?! It should be as a .vbs file.

grep

 

[TC]

Ow! Well caught. But who knows if she ever tried it

TC

 

[Guest]

Thanks, Jeff. I came here with the same question and the Digital Signature
solution is what I was looking for.

 

[Guest]

Thanks, Jeff. I came here with the same question and the "Digital
Signatures" solution was exactly what I wanted.

 

[Jeff Conrad]

You're welcome Scott, glad I could help.

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message