Thanks Scott - I don't think I would have got there on my own!

I couldn't find any references to this in any of the Infopath
texts I have read. I actually used your info to reset an existing database
path to use a workgroup. I was getting very frustrated that I had "read" but
not "write" access.

Took less than a minute to get this fixed. Brilliant!

Still new to Infopath but I can see its potential! Fantastic!

Regards, Oldie (Getting even older this week!)

Hi,

By chance, would the "user id's" be the same as the user's network logon?
If not, would you be able to have the user's enter their Access "user id"
in a field on the form?

There are only a couple of options for making this work:

- After you initially setup the connection information, modify the
Manifest.xsf file to remove the user id information and then when the user
sees the prompt, they would need to cancel that initial box and would then
get a prompt allowing them to enter user and password information.
- Using code, you could modify the connection string for your data
connection so that when the user executed the query, the code would
automatically either pickup their logon name or get it from a field on the
form so that they would only need to enter the password in the prompt that
appears.

Here is a VBScript example of this option - this would be used on the click
event of a button:

    Dim strConn
    Dim strFind
   
    strConn = XDocument.DataAdapters(0).connection
    strFind = "User ID="""""
    strConn = replace(strConn, strFind, "User ID = 'scott'")
   
    XDocument.DataAdapters(0).connection = strConn
    XDocument.Query

Let me know if you need any additional information on this!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights

Hi Smaur,

I believe the issue you are seeing is because the sample code I provided
was VBScript whereas you are using JScript.

Here is a modified sample using JScript:

function CTRL2_8::OnClick(eventObj)
{
    var strConn;
    var oNetwork = new ActiveXObject("WScript.Network");
    var strUserName = oNetwork.UserName;

    strConn = XDocument.DataAdapters(0).Connection;
    strConn = strConn.replace(/MyAdmin/, "Test");

    XDocument.DataAdapters(0).Connection = strConn;
    XDocument.Query();
}

You will notice the "replace" method is called differently and the letter
"C" in "Connection" needs to be capitalized.

Let me know how this works! :-)

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights

Hi Smaur,

That's great to hear - thank you for the update!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights

Hi,
I have followed Scott's suggestions in Posts #2 and #8 of this thread
my log on button code is below. My database connections have been se
with "Microsoft Jet 4.0 OLE DB Provider option" and with usernam
stored but no password stored.

function btnLogOn::OnClick(eventObj)
{
var strConn = XDocument.DataAdapters(0).Connection;
var strUserName
XDocument.DOM.selectSingleNode("//my:Username").text;
var strPassWord
XDocument.DOM.selectSingleNode("//my:PassWord").text;

strConn = strConn.replace(/myAdmin/, '"' + strUserName + '"');
strConn = strConn.replace(/Password=""/, "Password=" + '"'
strPassWord + '"');
XDocument.DataAdapters(0).Connection = strConn;
XDocument.Query();
}

But as it turns out, this isn't working afterall, when the button i
clicked the user is prompted with a dialog box titled "Please enter M
Jet OLE DB intialization information". I'd prefer if the user didn'
get this box for obvious reasons.
Apparently, although the 'XDocument.DataAdapters(0).Connection' no
holds the user inputted username and pwd, (I verified this with an
alert) InfoPath is not using it.

Any ideas as to what is wrong