Access DB timeouts

[Duran]

hello there, I am hoping one of you access wizards out there might be able to give me a clue to my problem. we have an online CRM application, and what we are finding is that those who log in and log out using the proper log out button never have a problem, but those that close the browser window using the x in the top right eventually have a problem.

IIS times out the connection, but I am wondering if the connection to the database remains open and eventually stops people who do not log out properly from eventually logging on. If we reboot the machine at night, we get one problem free day, but after that it persistes, there is nothing in the event log.

Its Access 2000 database. Is there a way of checking to see how many sessions are open on the DB at any one time, or a way of getting connections to time out?

Any help is much appreciated.
Regards,
D.

I plug you in, dim the lights,
Electric Barbarella !

 

[Remou]

You can examine the ldb file to find who is using the database.

 

[Duran]

Thank you very much.

Regards,
D.

I plug you in, dim the lights,
Electric Barbarella !

 

[Remou]

Some more notes:

Const dbSecUserRosterGuid = "{947bb102-5d43-11d1-bdbf-00c04fb92675}"
   Dim rs As ADODB.Recordset
   Dim con As ADODB.Connection
    
   Set con = CurrentProject.Connection
   Set rs = con.OpenSchema(adSchemaProviderSpecific, , dbSecUserRosterGuid)

    Do While Not rs.EOF
        For Each fld In rs.Fields
            Debug.Print fld.Name & ": " & fld
        Next
        rs.MoveNext
    Loop

And:

http://support.microsoft.com/default.aspx?scid=kb;en-us;186304

 

[PHV]

http://www.mvps.org/access/modules/mdl0055.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JoeAtWork]

You don't give any details of the architecture of your web application. What technologies are you using, DAPs, ASP, ASP.NET, etc?

How are you making a connection to the database? Do you have one global connection used by all sessions, does each session make it's own connection, or are connections opened and closed as needed?