I have a problem with this...It connects, does this...
code:
If $Recordset.RecordCount < 1
? "adding record"
$Recordset.AddNew
Endif
There are no errors, but also no data.
I made a DB and pointed the script to the right place, made 2 tables; TBL_USERS and TBL_COMPUTERS, then made the columns as specified here
code:
$Recordset.Fields("UserName").Value = @USERID
$Recordset.Fields("FullName").Value = @FULLNAME
$Recordset.Fields("Workstation").Value = @WKSTA
$Recordset.Fields("PrivilegeLevel").Value = @PRIV
$Recordset.Fields("HomeDrive").Value = @HOMESHR
$Recordset.Fields("LastUpdate").Value = @DATE + " " + @TIME
and so for the computer tableAre the com commands for access2000 different?