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 table

Are the com commands for access2000 different?

_________________________
How to ask questions the smart way <-----------> Before you ask