[AccessD] Idle Access seems to drop connection

David Emerson newsgrps at dalyn.co.nz
Thu Oct 19 15:45:56 CDT 2017


Hi Team,

 

I have a client that has several users with FE's connected to the same BE.
All of them seem to work fine except for 1 user.

 

When this user starts his copy there is a 30 second delay while the
programme opens (it gets data to display a report).  Then when the orders
screen is open via a command button it opens relatively quickly (within a
couple of seconds).

 

However, if he leaves the system for 5 minutes or so then the next time he
does something that requires getting data (for example closing and opening
the orders screen) there is a 30 delay again.  After the initial delay the
system works fast again.  If he immediately closes and opens the orders
screen without a delay between tasks then it opens immediately without a
delay.

 

I know there is a timeout setting for SQL connections but this is purely an
Access BE.

 

The IT company has checked the network (it is a wired network) and all seems
to be fine.  The user has another similar database (although smaller in data
size) and it doesn't have the same problem.

 

Any thoughts on what may be causing the delay?

 

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand

 

 



More information about the AccessD mailing list