It's not Crystal. The VFP ODBC driver has not been updated since VFP 6.0 and knows nothing about AutoInc fields nor database events. Use the VFP OLE DB provider instead.
>I added an auto incrementing field to a table. When I try to add this table to a Crystal report (Version XI), I get the following error:
>
>Database Connector Error: '42S02: [Microsoft][ODBC Viasual Foxpro Driver]NOt a table. [Database Vendor Code: 123]
>
>If I remove the auto increment field, I can add the table to the report. Does anyone have any ideas how to get around/fix this?
>
>Scott
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer