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

[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

 

[Scott McDaniel]

On 12 Jul 2006 10:03:12 -0700, (e-mail address removed) wrote:

Here's the link to the MS Access Security FAQ, step #34:
http://support.microsoft.com/?id=14....aspx?scid=/support/access/content/secfaq.asp

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

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

 

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