hi all,

i dont know why this happens.
i have the access database and i am accessing some fields of a table through ADODB.Command object.

VB Code:
  1. cmd.commandtext="select * from names"

  2. set rs=cmd.execute

but its giving run time error as "execute method of command object failed.."
do u know why this is so?
command object type,etc. all are correct.
please help
thanx in advance
ilikevb