 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / April 2006Changing path between FE and Password protected BE
Hello, I have a database that is split into FE and BE. The BE is protected with Password which the FE is providing when connected, using VB code. the users' path to the back end may differ from the path I used when setting up the front-end/back-end link. How can I let the user to change the path, without giving him the password to the BE? thanks, AviA Hi, you can use this code: http://www.mvps.org/access/tables/tbl0009.htm just add a password to connect property: .Connect = ";Database=" & strDBPath & ";PWD=MyPassword"  SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > Hello, > [quoted text clipped - 10 lines] > > thanks, AviA Hi Alex and thank you for the answer. I tried the code that you suggested, and as long the BE is without password, it works great. In the Function fRefreshLinks I've replaced the line .Connect = ";Database=" & strDBPath With the line .Connect = ";Database=" & strDBPath & ";PWD=2020" (2020 is the P.word) And something strange is happening: it allows me to reconnect the FE with the BE only once, and when I'm trying to reconnect again, I'm getting error #: 3031 – illegal Password. Do you have any idea why that is, and how it can be solved? AviA Hi, well, can't say right now, never had this. this code works at me for years. I would try to change password to something with text, to be sure that this is not a numbers only issue. SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > Hi Alex and thank you for the answer. > [quoted text clipped - 14 lines] > > AviA Are you closing the connection in the FE? Maybe it is dropping the connection, and not reestablishing it in the same way as you did initially. -Mike Tharp- > Hi, > well, can't say right now, never had this. this code works at me for years. [quoted text clipped - 30 lines] > > Message posted via AccessMonster.com > > http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200604/1 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.