Disable Security - Use the standard .mdw file - Allow external apps to connect using DAO vladimir.mcbadger[ at ]gmail.com 12.07.2006 17:03:12 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

Re: Disable Security - Use the standard .mdw file - Allow external apps to connect using DAO Scott McDaniel <scott[ at ]NoSpam_Infotrakker.com> 13.07.2006 01:30:16 On 12 Jul 2006 10:03:12 -0700, vladimir.mcbadger[ at ]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 [Quoted Text] >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[ at ]takemeout_infotrakker.com www.infotrakker.com

Re: Disable Security - Use the standard .mdw file - Allow external apps to connect using DAO vladimir.mcbadger[ at ]gmail.com 13.07.2006 22:29:15 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.