Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Operation is not supported for this type of object

Status
Not open for further replies.

LarryDeLaruelle

Technical User
May 19, 2000
1,055
US
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")

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

ClientID is not the primary key but 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
larry1de@yahoo.com

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top