[AccessD] Error: Your network access was interrupted

[Darryl Collins]

" I think unbound forms, in-line SQL and ADO might be your best resolution if you can't get Jet to hold onto connections reliably, and you may want to periodically refresh linked tables with code."

That would be the approach I would always use over a network.  Using anything 'bound' is risky IMHO.

Regards
Darryl.



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
Sent: Thursday, 10 November 2016 12:55 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Error: Your network access was interrupted

No experience with that particular error. It seems to me that this may be one of those things that accompanies linked tables and backends on servers where forms are bound. Can you redesign to work with unbound forms and/or temp (local) tables with recordet  logic rather than access binding logic?
I think unbound forms, in-line SQL and ADO might be your best resolution if you can't get Jet to hold onto connections reliably, and you may want to periodically refresh linked tables with code.

Seems a nuissance..

>From my non-flammable Note 3,
Bill Benson

On Nov 9, 2016 8:34 PM, "David Emerson" <newsgrps at dalyn.co.nz> wrote:

Hi Listers,



One of my clients is getting the following error:

"The expression After Update you entered as the event property setting produced the following error: Your network access was interrupted"



Does anyone have any experience with this.  Surfing indicates that it is a network issue rather than an Access one but I am working with another company in charge of the hardware and am trying to give them leads.



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