Re: VBA hanging over network - 2nd posting (more info)

From: Julia Boswell (jboswell_at_rockwellcollins.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 11:10:51 +0100

Thanks very much for your advice. I'll suggest sticking it on his pc, either
that or he moves buildings again! :-)
"Nick Coe (UK)" <classicnickNOSPAMAT@MASPON.yahooDOTcom> wrote in message
news:eYqsDIgTEHA.1244@TK2MSFTNGP10.phx.gbl...
> Julia,
>
> In those circumstances move it to the users PC.
>
> Network lags, corruption, collisions, restricted bandwidth
> will knacker the application.
>
> Access will work quite happily Front End on Client PC, Back
> End on Server but it has to be a good, sound network with
> plenty of bandwidth available. And probably set all network
> cards to half duplex can sometimes help since it can reduce
> congestion under some circumstances, though that needs
> experimentation on site..
>
> Not surprised it's pants, an IR link's effective data
> transmission rate can vary depending on where the sun is
> shining and if there are any flourescent lights in view...
> :-/
>
> Good luck
>
> --
> Nick Coe (UK)
> www.alphacos.co.uk
>
> ---
>
> "Julia Boswell" <jboswell@rockwellcollins.com> wrote in
> message news:unLUfAgTEHA.3616@TK2MSFTNGP11.phx.gbl...
> > Folks, I posted yesterday and didn't get an answer but I
> have some more info
> > and maybe someone can help me.....
> >
> > I've got some code behind an action button on a db held on
> a network (not
> > split as it's only used by a single user). The code has
> been tested ad
> > nauseam and works fine (it updates recordsets depending on
> certain criteria
> > using ADO), however my single user has recently started to
> get intermittent
> > problems when the code occasionally hangs for no apparent
> reason.
> >
> > What I've now found out, that I didn't know before, is
> that my user has
> > moved buildings and the network connection is different.
> The building he is
> > in is linked to the network with a PAV Gun (infrared) 10
> meg link. I know
> > nothing about networks at all, so I'm afraid I can't tell
> you much more than
> > that, other than to say I've spoken to the network manager
> and he says it's
> > a "pants" link and our company's weakspot.
> >
> > Could this be the problem? Has anyone suffered similar
> problems? I really
> > can't think of anything else it might be, unless anyone
> has any other
> > enlightened suggestions.
> >
> > I wonder if this is the problem, whether splitting the db
> would help, or
> > just moving it to the user's pc??
> >
> > Thanks in advance.
> >
> > Julia
> >
> >
>
>