Yah! These dbf files comes from our clients, they're just sending them to us to process, and not all of these foxpro tables have index. The task that was given to me is to change our current program's front end (from Visual Foxpro to VB6 since all of our projects are now created using VB6) while leaving the database input as is. I badly needed to index these tables automatically for the the program to process queries faster since these database contains huge amount of records and once i've performed a single query, the process is so slow :(. Also i think it's not applicable to create database index manually if the number dbf tables are not just one or two. Chitz :) -- modified at 23:36 Tuesday 17th January, 2006