Hi Matt, The login/password used by MIPro to log into an RDBMS source is saved in the connect string in the very un-encrypted TAB file. I.e. open for everybody to read. So usually one leaves out any passwords.
However, this forces MIPro to prompt for it when needing to reconnect (e.g. when refreshing). And there's no way to prevent this prompt, so you're stuck in the way you've set it up. But if you either use the MapBasic command "Server_Connect" to open the source and specify the connect string yourself, or use VB to connect directly to the source and provide the results to MapInfo, you should be able to keep the password safe from prying eyes. Best regards/Med venlig hilsen Lars V. Nielsen GisPro, Denmark http://hjem.get2net.dk/lars-online/ http://www.gispro.dk/ WGS84: 10.20'40"E 55.20'20"N ----- Original Message ----- From: "Matt Bolton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 03, 2002 7:54 AM Subject: MI-L Refreshing password-protected DBMS table > Hi all, > > Thanks largely to this list, my learning about programming with MI is > progressing rapidly, so I'd like to say a quick "Thanks" to those who > run and contribute to it.. > > On to the problem .... > > I have created a DBMS table which is linked to a password protected > Access database. In VB, I run the command > .do "Server Refresh [tablename]" > to refresh this link, at which time I'm prompted for a password. > I'd like for users to not see this prompt - i.e. have the password > entered via code. > I assume there is a simple way to do this , (something like .do "Server > Refresh [tablename], PWD=abcdef" > but can't find the syntax required. > > TIA, > > Matt > > -- > Matt Bolton > > Mach 3 IT > > Email [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 3886 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3887
