Yes it's a dBase file or a foxpro file. I need to get this information as well, but don't want to use classes if possible. steve Smith

oh yea, this database table has an index as well - I never did figure out how to utilize that index. I'm familiar with clipper but haven't done anything with a database in vb6 yet. Thanks again Steve

I'm working on a project that needs to search a database - one particular field of the database actually and find the record that contains the searched text in that field. If not found display a message box that states that then go load another form to add the record that isn't there. I don't want to use classes if possible. Is this possible with VB6? Steve Smith