VB database problem - error

dawballz

I get an error 3251 - "Operation is not suported by this type of object" when I run the following:

Dim thesearch As String
thesearch = "last name='" & txtLName.Text & "'"
Data1.RecordsetType = 1
If optSrchLastName.Value = True Then
Data1.Recordset.FindFirst thesearch        'debugger finds prob with this line
.....code

tried changing the recordsettype to 0 and 2 and it gives me the same error.
searched google and google groups with no help.. some suggestions to change recordsettype which i have already done with no good result.

oh yeah., i created the database with vb6 ->addins->visual data manager->ms access version 7.0MDB

FSL

Have you actually defined Data1 in your programme and opened a connection to the database.

dawballz

yep

is_that_so

where is the code that produces the recordset from the query?

Merrion

Some data sources are only forward-only - i.e. you can only move from one record forward to the next. Depends how you got the data in the first place.

dawballz

is_that_so wrote:

where is the code that produces the recordset from the query?

Ehmm... I dunno..?
I'm only new to VB, not really sure of all the terms etc.
But I can view all the records in the table no bother, skip back and forth through them and edit them and all...

ikoonman

Try this. Should point you in the right direction.

http://www.profsr.com/vb/vbless09.htm