windows username to ms access

orajat · #1 September 23rd, 2008, 02:41 PM

hi,

I'm trying to pull the windows username with jscript and save it to ms access field in a table, but it does not work. it does show the alert with the name of the user but does not save it to the ms access field. here i steh code that i'm using. please help

Expand|Select|Wrap|Line Numbers

 <SCRIPT type=text/javascript>

<!--

var WinNetwork = new ActiveXObject("WScript.Network");  

alert(WinNetwork.userName);
 
var adOpenDynamic = 2;

var adLockOptimistic = 3;
 
/* Path of database.

*/

var strDbPath = "C:\Documents and Settings\ASPIRE\Desktop\ss1 upgrade\SS1\db1";
 
/*

Here is the ConnectionString for Microsoft Access.
 
*/

var conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strDbPath;
 
function AddRecord() {

var adoConn = new ActiveXObject("ADODB.Connection");

var adoRS = new ActiveXObject("ADODB.Recordset");
 
adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='\\db1.mdb'");

adoRS.Open("Select * From TimeTrackerTable Where Group = 'xxxx'", adoConn, 1, 3);
 
adoRS.AddNew;

adoRS.Fields("Group").value = "(WinNetwork.userName)";

adoRS.Update;
 
adoRS.Close();

adoConn.Close();

}
 
function getAdoDb(strAdoType){

if (window.ActiveXObject){

return new ActiveXObject(strAdoType);

}

else{

return ActiveXObject(strAdoType);

}

}

</SCRIPT>

 <INPUT id=Button1 onclick=EditRecord() type=button name=Command0 ;><BR>

<SCRIPT language=javascript event=onclick for=Command0>

try { if (MSODSC.DataPages.Count > 0)

if (MSODSC.CurrentSection == null)

    MSODSC.DataPages(0).Save();

else

    MSODSC.CurrentSection.DataPage.Save(); }    

catch (e)

{ alert (e.description);}

</SCRIPT>

Regards,
xx

pronerd · #2 September 23rd, 2008, 07:57 PM

This is really more of an ActiveX question than a JavaScript one so you may want to try a forum that covers that.

I do see a number of issues, but I do not know if any of them are the problem.

First off the alert is being called because it is in the catch block. Some exception is being thrown causing the field value to not be set and causing the code in the catch block to execute instead.

Secondly the attributes in your HTML tags need to be surrounded by quotes. Third there is a semicolon in your input tag that should not be there.

The tags should look like this:

Expand|Select|Wrap|Line Numbers

<SCRIPT type="text/javascript">

Expand|Select|Wrap|Line Numbers

 <INPUT id="Button1" onclick="EditRecord()" type="button" name="Command0" />
 

Fouth the line below has a number of problems. All the attribute values need quotes. I do not see "event" or "for" as valid attributes for the script tag in any DOM documentation. Even if they are in IE how would you ever have an onclick event on a script tag. It is not rendered on the page and can not be clicked on.

Expand|Select|Wrap|Line Numbers

<SCRIPT language=javascript event=onclick for=Command0>

Last but not lest what you are trying to do is ex termly unsafe. I would be very surprised if IE will let you run this code by default even in the local zone. So you will probably have to lower your IE security setting all the way for this code to run.

orajat · #3 September 25th, 2008, 05:58 PM

security would not be a concern, the only problem i see is in line 27.....

pronerd · #4 September 25th, 2008, 08:07 PM

Quote:

Originally Posted by orajat

security would not be a concern,

It may not be a concern, but it is a problem. It is very unlikely that IE will let you do direct local system access in the default security settings. You will have to lower your security settings to the lowest point to be able to do local system access like this.

Quote:

Originally Posted by orajat

the only problem i see is in line 27.....

And you are basing that on what? Line 17 is not even inside the try catch block where the exception is being thrown. For that matter I do not even see where the function for the code on line 27 is called. What is calling the getAdoDb() function?

orajat · #5 September 26th, 2008, 06:54 PM

by problem i meant that the whole excercise is to save the windows username in the ms access field, which is not hapenning....

xx

Quote:

Originally Posted by pronerd

It may not be a concern, but it is a problem. It is very unlikely that IE will let you do direct local system access in the default security settings. You will have to lower your security settings to the lowest point to be able to do local system access like this.

And you are basing that on what? Line 17 is not even inside the try catch block where the exception is being thrown. For that matter I do not even see where the function for the code on line 27 is called. What is calling the getAdoDb() function?

windows username to ms access

re: windows username to ms access

re: windows username to ms access

re: windows username to ms access

re: windows username to ms access

/bytes/development

/bytes/it

/bytes/about