MI-L Refreshing password-protected DBMS table

[Matt Bolton]

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