This script should dump the db you created in your script:

break on

$db = "f:\msaccess\db1.mdb"

$cn = createobject("adodb.connection")

$cn.connectionstring = "data source=$db; provider=microsoft.jet.oledb.4.0;persist security info=false"

$cn.open()

$rs = $cn.execute('select * from inventory')

while not $rs.eof()

  ? $rs.fields("date") ":" $rs.fields("time") "-" $rs.fields("computername") " " $rs.fields("program")

 $rs.movenext

loop

$cn.close()
$cn = 0

exit 1



So it was in the manual - but wasn't documented in the new features text file that ships with the distribution (kix2001.txt) - heheh - serves me right for not reading the manual - Les is going to kick my a$$ !

-Shawn

[ 25 May 2002, 04:44: Message edited by: Shawn ]