Hmmm, I still can't seem to get it to work. I can't understand what i'm doing wrong but this is what I came up with. I hope someone can help me out with this one...

code:
$objConn = DBConnOpen('DRIVER={Microsoft Access Driver (*.mdb)}; UID=; PWD=; DBQ=C:\test.mdb')
$recordset = DBRecordsetOpen($objConn,'SELECT * FROM MyTable')

if $objConn
$numRecords=$recordset.RecordCount
? "Records: "+$numRecords
else
?"error"
endif

$retcode = DBRecordsetClose($recordset)
$retcode = DBConnClose($objConn)
Edit: oops, had a mispelling - still same problem though.

[ 19. August 2002, 19:36: Message edited by: punkie ]