Pervasive SQL 8.6 WG

Intensevdub · Jan 12, 2006

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 · Jan 12, 2006

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Pervasive SQL 8.6 WG

Intensevdub

IS-IT--Management

mirtheil

Programmer

Similar threads

Part and Inventory Search

Sponsor