>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.