Can't navigate recordsets using MySQL

[bir_maninder]

Hi Everyone

I am working on a simple project in VB6 using ADO and MySQL as the backend. The connection works fine, but i cannot navigate the recordset using the MoveFirst and the MoveLast methods. Whenever i attempt to do it i get an error saying:

Runtime Error '-2147217884 (80040e24)': Rowset does not support fteching backward.

Does this mean that i will not be able to navigate recordsets in VB using MySQL? or am i overlooking something? is there any other procedure to navigate through a recordset more efficiently?

Thanks in advance
Bir.

[kfcSmitty]

Could you post the code you're using to connect to/navigate the recordset, please?