I am using a VFP 3.0 free table. The following examples works fine when the field in the WHERE clause does not have a index tag on that field.

If the field in the WHERE clause does have a index tag, then the second command immediatley returns a 3219 invalid operation error message.

'********
Set db = OpenDatabase("d:\apps\web\data", _
False, False, _
"FoxPro 3.0")
Set l_tb = db.OpenRecordset("Select " _
& "pt_part, pt_desc, pt_product, pt_drawng " _
& "from depart where pt_part = '440' ", dbOpenSnapshot)
'********

Has anybody seen this before? I am using DAO 3.5. If I remove the index tag from the VFP table, then I can use the WHERE clause on any field. Otherwise, I can only use the where clause on non-index fields.

Thanks,

Jerryt