I started running into size issues with Access so my data now lives on SQL Server 2008. I'm still using the Access db, but instead of the table living in Access, it's linked to SQL Server. This way, all my queries still work.
The problem, is the attached code worked before and does not now. I get 'Object is not suported' on the Rst.Index.
Dim Dbs As Database
Dim Rst As Recordset
Set Dbs = OpenDatabase("\\GOLD-HP\faster\db.mdb")
Set Rst = Dbs.OpenRecordset("photos")
Rst.Index = "PrimaryKey"
Rst.Seek "=", value_picture_id
If Rst.NoMatch Then
'MsgBox "Not found!"