Open File Security Warning SP2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bringmewater@gmail.com - 16 Sep 2004 15:15 GMT

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 !!!

Reply to this Message

'69 Camaro - 16 Sep 2004 19:59 GMT

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

> 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
[quoted text clipped - 5 lines]
>
> Thanks !!!

Reply to this Message

topdog - 17 Sep 2004 13:14 GMT

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

> > are you sure you want to open
> > this, you might die warning
[quoted text clipped - 35 lines]
> >
> > Thanks !!!

Reply to this Message

'69 Camaro - 18 Sep 2004 01:16 GMT

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
[quoted text clipped - 42 lines]
> > >
> > > Thanks !!!

Reply to this Message

topdog - 20 Sep 2004 12:45 GMT

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.

Reply to this Message

'69 Camaro - 20 Sep 2004 13:27 GMT

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

> I set it to 2 or 0 and still get a prompt with macro security set to
> low.
[quoted text clipped - 5 lines]
>
> Thanks for any help. This is really annoying.

Reply to this Message

topdog - 21 Sep 2004 12:19 GMT

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.

Reply to this Message

Paul Overway - 22 Sep 2004 01:19 GMT

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

Signature

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

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

Reply to this Message

'69 Camaro - 22 Sep 2004 10:07 GMT

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=en&lr=&ie=UTF-8&c2coff=1&selm=%23EHnhZDoEHA.2
808%40TK2MSFTNGP10.phx.gbl

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

Reply to this Message

topdog - 22 Sep 2004 19:28 GMT

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

Reply to this Message

Paul Overway - 24 Sep 2004 16:59 GMT

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

Signature

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.

Reply to this Message

topdog - 22 Sep 2004 19:29 GMT

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.

Reply to this Message

'69 Camaro - 22 Sep 2004 20:16 GMT

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

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

Reply to this Message