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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 !!!

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" <(E-Mail Removed)_SPAM> wrote in message news:<OtyHG$(E-Mail Removed)>...
> > 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/vb...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.)
>
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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 !!!

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


"topdog" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)_SPAM> wrote
in message news:<OtyHG$(E-Mail Removed)>...
> > > 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/vb...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.)
> >
> >
> > <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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 !!!

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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

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.

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

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


"topdog" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

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=e...TNGP10.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.)


"topdog" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

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