I'm working on polling computers for disk space and writing to an access db. Here is a snip of what I'm using:

code:
 ;Setconsole ("HIDE")
$engine = "dao.dbengine.36"
$database = "c:\backup1\db1.mdb"
$dbe = olecreateobject ( "$engine" )
$dbs = val ( "&" + olecallfunc ( $dbe, "opendatabase", "s", "$database" ))
$Space = GetDiskSpace("\\romburner\c$")
$Server = "romburner"
$Drive = "C"
Gosub "Calculate"
Gosub "WriteToFile"
$Space = GetDiskSpace("\\romburner\d$")
$Server = "romburner"
$Drive = "D"
Gosub "Calculate"
Gosub "WriteToFile"
$Space = GetDiskSpace("\\towens2k\c$")
$Server = "towens2k"
$Drive = "C"
Gosub "Calculate"
Gosub "WriteToFile"
$Space = GetDiskSpace("\\towens2k\d$")
$Server = "towens2k"
$Drive = "D"
Gosub "Calculate"
Gosub "WriteToFile"

Goto "End"
:WriteToFile
;$X = Writeline (1, "Free Space On $Server $Drive Drive: " + "$ErrMsg" + Chr(013) + Chr(010))
$rs = olecallfunc ( $dbs, "execute", "s","INSERT INTO TABLE3 (Dato,Server,Drive,Space) VALUES ('@Date','$Server','$Drive','$ErrMsg');")
if @error goto End endif

The error I get says

"Sript error invalid function/method call: missing ")"!

$dbs = val ( "&" + olecallfunc ( $dbe, "opendatabase", "s", "$database" ))

Any help would be appreciated.
_________________________
I could have made a neat retort but didn't, for I was flurried and didn't think of it till I was downstairs.
-Mark Twain