Hi

I am getting this error message after the Seek command
run-time error 3251

which means the operation is not supported by this provider.

when I issue this code return not supported

Private Sub Command1_Click()
If rstUnit.Supports(adIndex) Then
MsgBox "index supported"
Else
MsgBox "not "
End If
If rstUnit.Supports(adSeek) Then
MsgBox "seek support"
Else
MsgBox "not "
End If
End Sub


I am using "Microsoft.Jet.OLEDB.4.0" access 97, and VB6 with SP6

anyone have any idea how to solve this.

Thankx in advance