Missing Table from list

[modglin]

Using Crystal 8.0. Have an ODBC connection to FoxPro database tables for Payroll/HR. When I connect I can access all of the tables except one PRHPOST. If I connect through Database Files I can see and use the table! However, if I link to it through database files, I cannot link any of the other tables to it. I can get data from one table but not the other and if I reverse link it gives me an error
xbase error:bad user specified key expression
and then the error message
error detected by database DLL.

 

[synapsevampire]

Is the ODBC to a DBC, or to a free table directory?

Perhaps if you change this you'll resolve the problem.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[modglin]

I believe free table directory. How do you create a DBC connection? I see .dbf, .db, .xls, .mdb and etc but not DBC (sorry to be so clueless)

 

[synapsevampire]

It's an option in the MS VFP ODBC driver.

Go to your DSN and select configure, the first screen should show Database Type as an option, with DBC as one choice.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com