Hello,

I'm writing a VB front-end to an MSDE database, and I'm getting the same error when I try to open the view. I'm using a Data Environment to create the connection to the database. Here's the code where the error occurs.

With deMusic.rsviewbyartist
.Open
.Find "artistid=" & id, , adSearchForward
Do While Not .EOF
Set itmx = lvwArtist.ListItems.Add(, "key" & !albumid, !albumtitle)
itmx.ListSubItems.Add , , !genrename
itmx.ListSubItems.Add , , !albumyear
itmx.ListSubItems.Add , , !mediumname
.Find "artistid=" & id, , adSearchForward
Loop
.Close
End With

Any help would be appreciated.