Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   MS Access connections issue with SQL server (http://www.go4expert.com/forums/ms-access-connections-issue-sql-server-t25062/)

Zamarrud 24Feb2011 23:17

MS Access connections issue with SQL server
 
Hello All,
We are facing an issue with MS access ADP project (SQL SERVER 2000 on backend) in production environment. Currently 20 users are using the application and they have their own copies of access application, when any user opens the application it creates three new connections with the database and keep them in sleeping status. Activity monitor shows the following processes in sleeping state,

1) SET NO_BROWSETABLE ON
2) select object_name(id), user_name(uid), ObjectProperty(id, N'IsScalarFunction'), ObjectProperty(id, N'IsInlineFunction'), ObjectProperty(id, N'IsMSShipped'), ObjectProperty(id, N'IsSchemaBound') from sysobjects where type = N'TF' and permissions(id) & 4096 <> 0
3) SET LANGUAGE us_english

When all users open their application number of processes reach to 60 and sql server got struck. Is their any way to minimize the number of connections?


All times are GMT +5.5. The time now is 08:57.