>BTW I never tried this. Maybe works. Try to add 'ENGINEBEHAVIOR=70' to your connection string.
>Cetin
The Extended Properties was auto appended when I put in ;ENGINE BEHAVIOR=70 text at end of original string
Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;Extended Properties="ENGINE BEHAVIOR=70"
Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;Extended Properties="ENGINEBEHAVIOR=70"
Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;Extended Properties="Engine Behaviour=70"
Now it doesn't seem to append Extended Properties
Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;ENGINEBEHAVIOUR=70
Provider=VFPOLEDB.1;Data Source=C:\VSO3\Projects\C04\DATA\VSO3VIEWS.DBC;Mode=Read;ENGINE BEHAVIOUR=70
None of the above worked.