1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MS Access connections issue with SQL server

Discussion in 'MS Access' started by Zamarrud, Feb 24, 2011.

  1. Zamarrud

    Zamarrud New Member

    Joined:
    Feb 24, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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?
     

Share This Page