Open File Security Warning SP2

[bringmewater]

I'm trying to open an MDB off my mapped drive file server and I keep
getting "open file security warning" are you sure you want to open
this, you might die warning.

How can I stop this prompt. This is my db that I created and I trust
myself. We have 10 users using this file so we need a way to stop it
for all.

Thanks !!!

 

['69 Camaro]

are you sure you want to open

this, you might die warning

LOL! The dialog window messages certainly _do_ sound like dire consequences
will befall the unlucky opener of the file!

If you are using Access 2003, then you can change the macro security setting
to low. If this is acceptable, then please see the "How to set the macro
security level in Access 2003 runtime" tip for the Windows Registry settings
to change or the source code (in both English and Spanish) to allow the user
to make this change from within Access on this Web page:

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

You can also create a digital certificate for you and the other users to
apply to each computer, but there are limitations to this, depending upon
the scope of the certificate -- one type is for your very own database
creations, another is for a domain, qne another one that costs money makes
the database available for worldwide disemination.

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.)

 

[topdog]

I have already set the macro security to low and it got rid of the 1st
message. With the mdb on a mapped drive I get 2 messages and now with
macro security set low I still get one. Any ideas how to get rid of
this message?

Thanks

 

['69 Camaro]

If the last error message remaining is the one that I think it is, make sure
that the following Windows Registry key:

\\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\SandboxMode

is set to either 0 or 2. (2 is the default.)

If your Registry already has one of these values assigned, then post back
with the error message you are receiving whenever you open the database from
the mapped drive.

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.)

I have already set the macro security to low and it got rid of the 1st
message. With the mdb on a mapped drive I get 2 messages and now with
macro security set low I still get one. Any ideas how to get rid of
this message?

Thanks



LOL! The dialog window messages certainly _do_ sound like dire consequences
will befall the unlucky opener of the file!

If you are using Access 2003, then you can change the macro security setting
to low. If this is acceptable, then please see the "How to set the macro
security level in Access 2003 runtime" tip for the Windows Registry settings
to change or the source code (in both English and Spanish) to allow the user
to make this change from within Access on this Web page:

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

You can also create a digital certificate for you and the other users to
apply to each computer, but there are limitations to this, depending upon
the scope of the certificate -- one type is for your very own database
creations, another is for a domain, qne another one that costs money makes
the database available for worldwide disemination.

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.)

[/QUOTE]

 

[topdog]

I set it to 2 or 0 and still get a prompt with macro security set to
low.

It says Open File Security Warning. Do you want to open this file?
Unknown Publisher

Really a PITA.

Thanks for any help. This is really annoying.

 

['69 Camaro]

Hi.

And this Windows Registry key is set to 1?

\\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level

If it already is, then you'll need to have a professional take a look at
your computer to diagnose the problem. Does your organization have an IT
department?

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.)

 

[topdog]

Camaro, Thanks again for the reply. There is no Security folder
under Access in the path you describe. Also, I'm the IT guy here and
am very good at Access and XP but this security warning seems
undocumented like many things, thanks for any help.

 

[Paul Overway]

Just curious...is the file on a samba share? Is it on a file server that is
part of your domain?

 

['69 Camaro]

Hi.

There is no Security folder
under Access in the path you describe. Also, I'm the IT guy here and
am very good at Access and XP

Then you're highly qualified to do the next steps. For a test, back up the
Windows Registry first, then try creating that Registry key on one computer
with the problem and see whether it prevents the Macro Security pop-up
warnings from displaying on that computer. The key is:

\\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level

The type is DWORD, and for low security, the value should be 1.

this security warning seems
undocumented like many things

In just the last few months, Microsoft has placed a bunch of new
documentation about this on their Office Online Support Web pages, but you'd
still have to know where to find it. Fortunately, Jeff Conrad posted a list
of links for a similar News Group question that you can find on this Web
page:

http://groups.google.com/groups?hl=...=1&selm=#[email protected]

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.)

 

[topdog]

The file is on a win2000 server that we map to. We don't log into the domain.

 

[topdog]

Also, this did not stop the message

\\HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Level

The type is DWORD, and for low security, the value should be 1.

 

['69 Camaro]

Hi.

Then I think I've done as much troubleshooting as I can from a distance. I
would need to see your computer in person to go further. Perhaps Paul
Overway has some suggestions for you to try.

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.)

 

[Paul Overway]

The problem is your IE Security settings....the file is outside of your
domain (local machine), hence the warning.

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com

The file is on a win2000 server that we map to. We don't log into the

domain.