Pervasive SQL 8.6 WG

[Intensevdub]

Our accounting package uses the 8.6 Engine. We are trying to extract information using MS Access. An ODBC connection can be created and I can link tables into Access. When I open a certain table, one of the columns is missing information, but when I look at it using the Control Center the column contains data.

As well I have linked another table into access and when I open the table, there is an error saying record to large

Anyone have any ideas as to why this happens?

 

[mirtheil]

Sounds like a problem with Access. If the PCC shows the data, then the data is there. PCC (in v8) uses ODBC. You might try another ODBC tool (like Crystal Reports or MS QUery) to access the data. If it shows the data, then the problem is in Access and you'll need to talk to Microsoft.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com