>Hi Eric,
> I don't want to create index in Access. I want to create index and
>primary key on the recordset or on the temp curosr which i have
>made in memory using ADO method. so pls. help me . . . .

You can't add index to a recordset.

A recordset is only fields retrieved from a table that an application can use.

Index and primary keys are physical and exist only at the database level. When you query the database, keys and indexes can be used!