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:53:14 +0100

Nick

Just having spoken to the user, it will apparently be impractical to put the
db on his c drive as, occasionally, someone else on the network opens the db
to read data (doesn't do any data entry). Keeping it on the network would
therefore be preferable, and I guess it helps with automatic backups.

Another thought is to use BeginTrans and CommitTrans (which I've never done
before) as a fail safe, e.g. the user presses the action button and if the
network fails for some reason the transaction is rolled back and the user is
told and asked to try again, which is better than now where the app just
hangs.

Would this be a practical solution? and if so, would the db need splitting,
or could this work over the network. Apologies for my ignorance on this
subject, it's not something I've come across before!

Julia
"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
> >
> >
>
>