Disk or Network Error & Windows - Delayed Write failed Error

Discussion in 'Access General' started by MOM IT Helpdesk, Nov 18, 2005.

  1. Hi,

    We have Microsoft Access databases/files which are shared in a network
    drive. Users are using Access 2003 from their workstations which are
    using Windows XP Pro in a domain environment.

    When accessing the Access files, they will encounter errors as in the
    subject above.
    We have followed the solution from
    http://support.microsoft.com/default.aspx?kbid=321733 but it does not
    work.

    The problem will occur when users open the file and use it for about
    15-20 minutes. Recently the time when the errors are hit has become
    shorter to 30 seconds.
    Users have to close the files and open them up again to re-access. We
    have tested with Excel and Word files in the network drive but they did
    not give such problems. Only Access files are affected.
    All users who are given access to these Access files are having the same
    problem.

    We would like to have advice on this issue.
     
    MOM IT Helpdesk, Nov 18, 2005
    #1
    1. Advertising

  2. MOM IT Helpdesk

    SusanV Guest

    I would split the database and distribute the front-end to your users. Not
    only will this help immensely with network issues, but also prevent
    corruption.
    --
    hth,
    SusanV



    "MOM IT Helpdesk" <MOM IT > wrote in
    message news:...
    > Hi,
    >
    > We have Microsoft Access databases/files which are shared in a network
    > drive. Users are using Access 2003 from their workstations which are
    > using Windows XP Pro in a domain environment.
    >
    > When accessing the Access files, they will encounter errors as in the
    > subject above.
    > We have followed the solution from
    > http://support.microsoft.com/default.aspx?kbid=321733 but it does not
    > work.
    >
    > The problem will occur when users open the file and use it for about
    > 15-20 minutes. Recently the time when the errors are hit has become
    > shorter to 30 seconds.
    > Users have to close the files and open them up again to re-access. We
    > have tested with Excel and Word files in the network drive but they did
    > not give such problems. Only Access files are affected.
    > All users who are given access to these Access files are having the same
    > problem.
    >
    > We would like to have advice on this issue.
    >
     
    SusanV, Nov 18, 2005
    #2
    1. Advertising

  3. "SusanV" wrote:

    > I would split the database and distribute the front-end to your users. Not
    > only will this help immensely with network issues, but also prevent
    > corruption.
    > --
    > hth,
    > SusanV
    >
    >
    >
    > "MOM IT Helpdesk" <MOM IT > wrote in
    > message news:...
    > > Hi,
    > >
    > > We have Microsoft Access databases/files which are shared in a network
    > > drive. Users are using Access 2003 from their workstations which are
    > > using Windows XP Pro in a domain environment.
    > >
    > > When accessing the Access files, they will encounter errors as in the
    > > subject above.
    > > We have followed the solution from
    > > http://support.microsoft.com/default.aspx?kbid=321733 but it does not
    > > work.
    > >
    > > The problem will occur when users open the file and use it for about
    > > 15-20 minutes. Recently the time when the errors are hit has become
    > > shorter to 30 seconds.
    > > Users have to close the files and open them up again to re-access. We
    > > have tested with Excel and Word files in the network drive but they did
    > > not give such problems. Only Access files are affected.
    > > All users who are given access to these Access files are having the same
    > > problem.
    > >
    > > We would like to have advice on this issue.
    > >

    >
    >
    > Hi SusanV,


    Are you suggesting that this is a network issue? It seems that only Access
    files are affected. Are there any configuratiosn that can be done on the
    client side (workstations) instead of disturbing the files in the server?
    Could this be due to the timeoutsession of the workstation and how can we
    rectify that?
    What do you mean by 'distribute the front-end to users'?
     
    MOM IT Helpdesk, Nov 19, 2005
    #3
  4. MOM IT Helpdesk

    Tony Toews Guest

    "SusanV" <> wrote:

    >I would split the database and distribute the front-end to your users. Not
    >only will this help immensely with network issues, but also prevent
    >corruption.


    Splitting will help with a lot of issues and it will reduce the
    chances of corruption but it certainly won't prevent corruption.

    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 Toews, Nov 29, 2005
    #4
  5. MOM IT Helpdesk

    Tony Toews Guest

    MOM IT Helpdesk <MOM IT > wrote:

    >We have Microsoft Access databases/files which are shared in a network
    >drive. Users are using Access 2003 from their workstations which are
    >using Windows XP Pro in a domain environment.
    >
    >When accessing the Access files, they will encounter errors as in the
    >subject above.


    Disk or Network Error usually means some sort of hard ware. Such as
    an intermittently faulty network card or cable or something else.

    Is this happening on only one, a few or all workstations? Are these
    wireless connections?

    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 Toews, Nov 29, 2005
    #5
  6. "Tony Toews" wrote:

    > MOM IT Helpdesk <MOM IT > wrote:
    >
    > >We have Microsoft Access databases/files which are shared in a network
    > >drive. Users are using Access 2003 from their workstations which are
    > >using Windows XP Pro in a domain environment.
    > >
    > >When accessing the Access files, they will encounter errors as in the
    > >subject above.

    >
    > Disk or Network Error usually means some sort of hard ware. Such as
    > an intermittently faulty network card or cable or something else.
    >
    > Is this happening on only one, a few or all workstations? Are these
    > wireless connections?
    >
    > 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
    >



    Hi Tony,

    It happened to all workstations and they are not using wireless. Users are
    using LAN connection in a domain. If you are suggesting hardware, then how
    come only Access databases are affected and not Words or Excels in the shared
    drive?
     
    MOM IT Helpdesk, Nov 30, 2005
    #6
  7. MOM IT Helpdesk

    John Vinson Guest

    On Tue, 29 Nov 2005 18:28:01 -0800, MOM IT Helpdesk
    <> wrote:

    >It happened to all workstations and they are not using wireless. Users are
    >using LAN connection in a domain. If you are suggesting hardware, then how
    >come only Access databases are affected and not Words or Excels in the shared
    >drive?


    A client of mine has been pestered with this "Disk or network error".
    As Tony says, it usually IS a network error; Access is MUCH more
    demanding of network resources than Word or Excel or most other
    programs. But in my client's case, it appeared to be a bogus error,
    the result of either database corruption, or a client computer using a
    different service pack level than the "backend" computer.

    Make sure that all users are up to date with the same service packs;
    compact and repair all databases; and monitor to see if the error
    occurs particularly for one or two users. If it does, doublecheck
    their network connections (and maybe swap their ethernet cards with
    another machine that doesn't use Access).

    John W. Vinson[MVP]
     
    John Vinson, Nov 30, 2005
    #7
  8. MOM IT Helpdesk

    Tony Toews Guest

    MOM IT Helpdesk <> wrote:

    >It happened to all workstations and they are not using wireless. Users are
    >using LAN connection in a domain. If you are suggesting hardware, then how
    >come only Access databases are affected and not Words or Excels in the shared
    >drive?


    Access is continuously pumping a small amount of data up and down the
    wire with a 2.5 kpbs burst every 25 or 30 seconds. You can see this
    by running Task Mgr and watching the network connection traffic.
    More traffic is generated every time you read or write data.

    Word and Excel only read and write data in bursts as you open and save
    files. So their behaviour is much different.

    Now as John states it could be different Jet Service Packs and such
    too although that hasn't been what I've observed in the newsgroups.

    For more information on corruption including possible causes,
    determining the offending PC, retrieving your data, links, official MS
    KB articles and a list of vendors who state they can fix corruption
    see the Microsoft Access Corruption FAQ at
    http://www.granite.ab.ca/access/corruptmdbs.htm

    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 Toews, Nov 30, 2005
    #8
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. tjmc22

    Windows Delayed Write Failed message

    tjmc22, May 29, 2007, in forum: Outlook General
    Replies:
    1
    Views:
    268
    Vince Averello [MVP-Outlook]
    May 29, 2007
  2. Aniruddha_Kaslikar
    Replies:
    1
    Views:
    123
    Aniruddha_Kaslikar
    Dec 27, 2009
  3. Raj

    "Delayed Write Failed" Error Message

    Raj, Mar 2, 2005, in forum: Access Macros
    Replies:
    0
    Views:
    37
  4. Delayed write failed

    , Oct 20, 2003, in forum: Excel Setup
    Replies:
    1
    Views:
    55
    Haldun Alay
    Oct 21, 2003
  5. Jason

    'Delayed Write Failed' fix failed

    Jason, Jan 24, 2005, in forum: Word Errors
    Replies:
    1
    Views:
    75
Loading...

Share This Page