Disable Security - Use the standard .mdw file - Allow external apps to connect using DAO

12 Jul 2006 5:03 PM

vladimir.mcbadger

I have a database that I tried to implement the access security using a
stand alone .mdw security file.

I no longer want to have the security implemented and want to make the
DB completely unsecure.

I have sort of achieved this - I can now distribute the DB freely and
people can open it. But when I try to connect to the DB from external
sources (e.g. using DAO from Excel) I get the error "You do not have
the necessary permissions to open c:\......\..MDB" Please seek your
administrator.

If I try to connect to a different DB in the same folder I have no such
issues. I am presuming that I managed to secure the DB from being
accessed externally somehow???

I am rather out of my depth here so I apologise if my message is a bit
criptic but would really like to be able to connect to this DB from
Excel?

TIA

13 Jul 2006 1:30 AM

Scott McDaniel

On 12 Jul 2006 10:03:12 -0700, vladimir.mcbad***@gmail.com wrote:

Here's the link to the MS Access Security FAQ, step #34:
http://support.microsoft.com/?id=148555http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp

Also a link to Joan Wild's site (see the Remove Security on a Database link):
http://www.jmwild.com/Accesssecurity.htm

Show quoteHide quote

>I have a database that I tried to implement the access security using a
>stand alone .mdw security file.
>
>I no longer want to have the security implemented and want to make the
>DB completely unsecure.
>
>I have sort of achieved this - I can now distribute the DB freely and
>people can open it. But when I try to connect to the DB from external
>sources (e.g. using DAO from Excel) I get the error "You do not have
>the necessary permissions to open c:\......\..MDB" Please seek your
>administrator.
>
>If I try to connect to a different DB in the same folder I have no such
>issues. I am presuming that I managed to secure the DB from being
>accessed externally somehow???
>
>I am rather out of my depth here so I apologise if my message is a bit
>criptic but would really like to be able to connect to this DB from
>Excel?
>
>TIA

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

13 Jul 2006 10:29 PM

vladimir.mcbadger

Thanks Scott,

I tried the method from the access FAQ but that doesn't include the
additional step of having to copy all the objects into a new database.

All I needed to do then was add all the VBA references back in and I
can now query my database from external programs.