Operation is not supported for this type of object 1

[LarryDeLaruelle]

Using Access '97 w/SR2.

I have the following code that was working properly until just a few days ago. I checked help and, I think, that I have set it up correctly, but when it hits the rsTemp.Index line it errors:

Set dbTemp = CurrentDb
Set rsTemp = dbTemp.OpenRecordset("tblBase32Intk&quot

rsTemp.Index = "ClientID"
rsTemp.Seek "=", ClientID

ClientID is a numeric field but is not the primary key on the table being queried (it is indexed (dups OK)).
I have compacted/repaired but still get the error.

I have three references set: VB for Apps; MS Access 8.0 Object Lib; MS DAO 3.51 Object Lib.

Any idea why this would suddenly start acting up?

Thanks. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[jebry]

Hi Larry!

Is tblBase32Intk a linked table? If it is then the default recordset type will be Dynaset which doesn't support Index or Seek. The only recordset type that does support these methods is the Table Type, but that can only be used with local tables, not linked ones.

hth Jeff Bridgham
bridgham@purdue.edu

 

[LarryDeLaruelle]

Jeff:

Thank you very much. That is indeed the case.

I had to split the db into front and back ends. Now it dawns on me that the error started to occur after the split.

We'll mark it down to old age that I didn't make the connection sooner and that I didn't read far enough down the help to see the second to last paragraph that says what you just told me.

Thanks again. Larry De Laruelle
ldelaruelle@familychildrenscenter.org