>From my VFP program i was creating ODBC connection programatically but how can i create a VFPOLEDB connection progamatically from VFP so that Crystal Reports can access the table.
>
>I have approx 50 reports created in CR 8.5 and all the reports were using ODBC connection so how can all these reports be changed to start using VFPOLEDB connection?
>

In addition to Al's post: You might try the advantage ODBC driver, this should support the newer features of vfp,
up to and including autoinc and binary indexes.

HTH

thomas