[AccessD] Idle Access seems to drop connection

[The Smiley Coder]

There are a few steps to try to resolve this:
1) Simplest step to implement is to ensure the app has a persistent
connection. It might have not be required for other users, but is for him,
due to how the AD groups might be setup. Simple to implement, just open a
hidden form on startup that connects to a table on the backend, and leave
that form open (and hidden)

Other then that, we can try to physically rule out a few things:
A) Fresh frontend for the user. This eliminates suspicion on the specific
file. If distributing accdb, the chance of files going odd is quite a bit
higher.
B) Physically move the user to another network cable, of a user that you
know to be working. This rules out the network.
C) If possible, have the user use another PC. This rules out the users
PC/network card from the list of suspects.

Best regards
Anders Ebro // TheSmileyCoder <http://www.thesmileycoder.com>
Access MVP 2014-2018
<http://mvp.microsoft.com/en-us/mvp/Anders%20Ebro-5000469>

On Fri, Oct 20, 2017 at 12:08 AM, Jim Dettman <jimdettman at verizon.net>
wrote:

> Windows drops inactive mapped network drives....default is 10 minutes.
>
> You can disable that with a GPO or by modifying the registry.
>
> Other potential item; do you keep a connection open to the backend for The
> life of the app? Could be the connection to the backend database is closing
> and when logging back in again there’s quite a bit of overhead.  30 seconds
> is excessive though.
>
> More than likely it’s a map drive disconnecting
>
> Jim
>
> Sent from my iPhone
>
> > On Oct 19, 2017, at 5:56 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:
> >
> > Hi Arthur,
> > The user can have the orders screen open and just not doing anything
> with it
> > for 5 minutes.  When he then tries to run a report from that screen, or
> > close the screen and reopen it (i.e. query the database again) there is
> the
> > delay.  In this case isn't the orders screen effectively doing what you
> > suggest?
> > Regards
> > David
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > Arthur Fuller
> > Sent: Friday, 20 October 2017 10:24 a.m.
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Idle Access seems to drop connection
> >
> > There have been threads on this. If you declare a public variable and
> open a
> > recordset witb it you won't lose your connection.
> >
> > On Oct 19, 2017 4:47 PM, "David Emerson" <newsgrps at dalyn.co.nz> wrote:
> >
> > 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
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>