could any one teach me how to refrence Indexes table of access db. For example if we have a table player with following fields: pplayerno,name,initial and playerno as primary key. Now i want to know how can i use vba to obtain indexes name of Indexs: players and if it is pimary :no or Unique : yes for each index name in Indexes: players table.Thanks