> strdbname = "c:\bardice3\hiscore.mdb"
> strrsname = "hiscore"
> Set db = DBEngine.OpenDatabase(strdbname)
> Set tdfHiScore = db!hiscore
> Set rs = db.OpenRecordset(strrsname, dbOpenTable)
> Set idxScore = tdfHiScore.Indexes("ScoreIndex")
> tdfHiScore.Indexes.Refresh
Ok, yes you are using DAO (the DBEngine gave it away)
I think what you need to do (and it's been a LONG time since I've used DAO), is open the database, then open a open a recordset with the table name, and then set the index on the recordset.
I do not know the syntax for this off the top of my head, but if you need it I could figure it out.
Jay Shepherd