Recently we have deployed Jet Service Pack 8.0 for our applications, until then we used to run Jet service Pack 6.0 and the applications were running fine. After we installed service Pack 8.0 some of our access queries hangs permanently. These are insert queries (join to multiple tables in SYBASE database and insert into a temporary table in MS Access), and when I run these queries Access simply hangs, I searched searched and finally reverted back to the Older versions (of jet service pack 6.0) of DAO360.DLL and MSJET40.dll, then the queries started running fine again.
I didn't revert other DLLs installed by service back 8.0, My question is why does it happen with this new service pack 8.0 ??
Is there any patch to this patch ??
As part of the policy we need to go to service pack 8.0 sooner or later so I only got the temporary solution to get the applications working by copying the older versions of the DLLs.(of service pack 6.0)
I need to know any permanent fix so that I can use Jet service Pack 8.0 without any issues.
Any help would be appreciated.