Use Ms Access to open Peachtree Data

[dowchee]

Hello,

I have Peachtree 2004, Pervasive Sql 8.5, and Ms Access 2003.

I can use Pervasive Sql control center to open Peachtree's JrnlHdr.

I create an ODBC and I tried to use Ms Access to link JrnlHdr. All I get the field are "#Delete" and "#Name"

How can I correct this problem?

Thanks

 

[mirtheil]

Usually, the #DELETE and #NAME indicates an error occurred. You might have to turn on ODBC tracing to see the "real" error because Access doesn't display it. Make sure you display the records in "Text" mode within the PCC. Sometimes the "Grid" mode doesn't show all errors.
You can try limiting which fields are displayed to see if you can narrow down which field is causing the problem. Most of the time, it's a value within a field that's causing the problem.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com