>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 figured out a different way to do what I needed that didn't need indexing. But I'm sure I'm going to need it one day. So I'm going to try that.

Also, since you don't use DAO, what do you use? I'm just learning VB and want to make sure I'm learning the most useful stuff.

Thanks!