Re: Network Shortcut Problems

"Chris Mills" <phad_nospam@xxxxxxxxxxxxxx> wrote:

Thanks for your response. I realize that there are structural problems with
the setup (no front end / back end split), but that's just how it has to be
to suit our application.

A non-split database will "work" networked with several users, so that is not
your direct problem here.
(I once ran 4 users networked in a similar way for months, and it seemed OK)

Access 97 was much more stable in this regard. I still had some
corruptions though.

(Don't ask me how reliability of the OS/Network works! I thought, corrupted
file reads were detected by the likes of parity or better and re-sent. At the
OS level. Nevertheless, theory being just an amusement, the "macroscopic"
results in Access seem to be universal - corruption happens!)

I think it's more a matter of the network component OS keeps retrying
to send the data but finally gives up. And Access times out pretty
quickly too. And if only some packets get through then Jet really
has a tough time with things.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: Improving performance over the WAN
    ... else low demand for the service, I don't know which) I could count on finding ... When the network was marginal, ... better than not having it by a pretty wide margin. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Why does splitting a mdb make it slower?
    ... had a frontend on the hard drive and the backend on the network things ... Also it's my understanding that MS did a great deal of work in Win 2003 Server to get ... it as fast as Novell as that was one area in which they were getting beat up on. ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: Relationships - Multiple Back End Files
    ... Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele ... (information that gets updated on a regular bases - Activities, ... network I was assuming this would in face speed up everything as it ... reside (my understanding is that relationships should be stored in the ...
    (microsoft.public.access.formscoding)
  • Sharing self stopped...
    ... Symantec Endpoint Protection, Microsoft Access, Windows Networking, or my ... I had been sharing out Microsoft Access database from my terminals all ... network sharing had hang-up in the middle of session of using the database. ...
    (microsoft.public.windowsxp.network_web)
  • Re: Citrix occasionally corrupting row of data.
    ... You can view the actual screen shot here ... ... When the database was closed, ... This comes in quite useful in tracking corruptions. ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)