Thanks in advance!
My software uses Actian 12 (Pervasive) WGE. x32 with SIMBA ODBC drivers. We have a client with a query in Access 2013 32-bit and our log files are showing that it is logging in and out of our dissents of times, slowing the query to an absolute crawl and basically unusable.
All of the DSN's work outside of these queries and the connection is lightning fast when testing. The crawl only happens with these queries.
It last worked when they were using Pervasive v11 WGE/SIMBA ODBC drivers. I am not competent in Access at all! None of us really are but we do see the problem in our software. It looks like it is requesting our software credentials every time a new record is being brought over into Access.
Any input would be greatly appreciated.