Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access 97 on Tserver 2003

Discussion in 'Information Technology' started by Richard, Jul 28, 2006.

Tags:
  1. Richard

    Richard
    Expand Collapse
    Guest

    We've just had to move over an old Access 97 application from Win2000
    TServer to Win2003 TServer.

    After the usual fiddling around to get things working (permissions etc) like
    often with TS apps, there's one problem left. The server is very slow. The
    access.exe process that every TSuser uses is at the top of the CPU list all
    the time, one after the other. CPU is 100% loaded. We've tried several
    things without results.

    Even when we use a simple test Access MDB on the Tserver, the CPU goes to
    100%.

    I'm beginning to think Access 97 doesn't like Win2003, or vice versa. Could
    this be the case ?
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Take a look at http://support.microsoft.com/?id=160819

    While it looks as though Access is hogging the CPU, it should not be
    impacting the performance of any other applications.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Richard" <helpdesk@ortec.nl> wrote in message
    news:44b4e92f$0$13741$e4fe514c@dreader25.news.xs4all.nl...
    > We've just had to move over an old Access 97 application from Win2000
    > TServer to Win2003 TServer.
    >
    > After the usual fiddling around to get things working (permissions etc)

    like
    > often with TS apps, there's one problem left. The server is very slow. The
    > access.exe process that every TSuser uses is at the top of the CPU list

    all
    > the time, one after the other. CPU is 100% loaded. We've tried several
    > things without results.
    >
    > Even when we use a simple test Access MDB on the Tserver, the CPU goes to
    > 100%.
    >
    > I'm beginning to think Access 97 doesn't like Win2003, or vice versa.

    Could
    > this be the case ?
    >
    >
    >
    >
    >
     
  4. Richard

    Richard
    Expand Collapse
    Guest

    Well it certainly affects the performance of the server, or at least other
    processes on the server.

    "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
    news:OOwGQJbpGHA.4932@TK2MSFTNGP05.phx.gbl...
    > Take a look at http://support.microsoft.com/?id=160819
    >
    > While it looks as though Access is hogging the CPU, it should not be
    > impacting the performance of any other applications.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Richard" <helpdesk@ortec.nl> wrote in message
    > news:44b4e92f$0$13741$e4fe514c@dreader25.news.xs4all.nl...
    >> We've just had to move over an old Access 97 application from Win2000
    >> TServer to Win2003 TServer.
    >>
    >> After the usual fiddling around to get things working (permissions etc)

    > like
    >> often with TS apps, there's one problem left. The server is very slow.
    >> The
    >> access.exe process that every TSuser uses is at the top of the CPU list

    > all
    >> the time, one after the other. CPU is 100% loaded. We've tried several
    >> things without results.
    >>
    >> Even when we use a simple test Access MDB on the Tserver, the CPU goes to
    >> 100%.
    >>
    >> I'm beginning to think Access 97 doesn't like Win2003, or vice versa.

    > Could
    >> this be the case ?
    >>
    >>
    >>
    >>
    >>

    >
    >
     
  5. never_be_read@yahoo.com

    never_be_read@yahoo.com
    Expand Collapse
    Guest

    Richard,

    As far as I remember, Access 97 always show up as running 100%
    even on NT4. I think it may have something to do with the old way
    Windows application do things - non-pre-emptive??

    I am not a TS guy. Can't help you. Sorry. Duncan

    Richard wrote:
    >
    > Even when we use a simple test Access MDB on the Tserver, the CPU goes to
    > 100%.
    >
     
  6. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Richard" <helpdesk@ortec.nl> wrote:

    >I'm beginning to think Access 97 doesn't like Win2003, or vice versa. Could
    >this be the case ?


    Correct. A client reported the exact same problem with A97 on a TS
    system. I don't recall though if the OS was Win 2000 Server or Win
    2003 Server.

    Once they installed Access 2000 all was fine.

    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
     
  7. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Tony Toews wrote:
    > "Richard" <helpdesk@ortec.nl> wrote:
    >
    > > I'm beginning to think Access 97 doesn't like Win2003, or vice
    > > versa. Could this be the case ?

    >
    > Correct. A client reported the exact same problem with A97 on a TS
    > system. I don't recall though if the OS was Win 2000 Server or Win
    > 2003 Server.
    >
    > Once they installed Access 2000 all was fine.
    >
    > Tony


    Our company's experience was the same. The high cpu utilization that was
    "harmless" in NT 4.0 brought the Server 2003 box to its knees. Going to Access
    2000 fixed it.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     

Share This Page