Recordset Error

hi
i get a run time error '- 2147467259 (80004005)' which says 'method open of object _recordset failed' . i get this error on a particular table, if i change the table name in the query it works fine again, i tried to delete the table and then made it again but same error,
by the way am using Adodb.Recordset on an Access Database!
pls help

what is the name of the table that you are trying to use?

the name of the table is "SaleD" which is the foreign key table of my "SaleM" table but da thing is dat is tried the exact same query in access n it executed perfectly

Quote:

---

'method open of object _recordset failed'

---

maybe u forgot to set New of the Recordset? or ur SQL Syntax is not right.
post the code

Is it more than one query per recordset? You used the wrong cursor (forward only?)

I found this:

http://support.microsoft.com/default...b;en-us;180843