praveenpoli
asked on
Jet Service Pack 8.0 problems.
Hi,
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.
Thank You.
Praveen.
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.
Thank You.
Praveen.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Actually, I just did some testing the other day and and opening a saved query via code in DAO vs ADO is almost twice as fast.
if you are within the MDB I always recommend DAO.
Mike
if you are within the MDB I always recommend DAO.
Mike
Works better and faster than DAO...
and install MDac 2.7 too...