Hi guys,

I am having a table with a primary key as AUTO INCREMENT.

When i try to open this table in Crystal Reports using ODBC i get the error

<b> ODBC error: [Microsoft][ODBC Visual Foxpro Driver] Not a table </b>

Going back to the table in foxpro, if i change the Integer (Auto Inc) to INTEGER, i am able to access this table in CR using ODBC. So it seems that INTEGER AUTO INC is causing problem with ODBC drivers.


Then i setup a "VFPOLEDB for Visual Foxpro" connection and i am able to access the table in Crystal Reports without any problem.

<h2><b>MY PROBLEM</b></h2>

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?

Any help/suggestions/ will be highly appreciated.

sanjay