Extremely slow query with P.Sql 2000 and Access 97

[Guest_imported]

I have a P.Sql2000 table(Transaction History) that I have linked into my Access 97 database that runs extremely slow and reports erroneous data when I run a query on it. I have similar tables though(Order Master, Part Master) that just hum when running a simple select query. These tables give me accurate data too. I was wondering if anyone has ever had problems with the T-history(KEWILL MAX ERP SYSTEM) File in particular??

Any Input is greatly appreciated
John D

 

[TomKane]

When I first started trying to use Pervasive and VB together I found that the jet data engine gave me wrong results from queries - I don't know if you have the same problem but you might look at the method with which you're accessing Pervasive.

 

[vbajock]

You need to upgrade the underlying Jet database engine in Access. I think you can find the update on Microsoft's web site - it might require you to upgrade to at least Access 2000 tho