Slow response on only one PC

Re: Slow response on only one PC

On 4 Apr 2006 19:08:16 -0700, "LSloan" <lsloancl@yahoo .com> wrote:

From the Access version number I can see you're not on the latest. Run
Office Update to correct that.
Also find the latest version of Jet 4.0 on microsoft.com, and apply
that.
Run SpyBot (http://www.spybot.info/) to check for spyware.
Check out this page:


-Tom.


[color=blue]
>Hi,
>
>I have an Access application installed on a network server that is
>accessed by several users. It isn't split into a front-end/back-end (I
>know it should be but when I've tried, the response time for all users
>is unacceptable). It has been working fine for many months, for all
>users. Recently, for one user, the response time has been unacceptable
>with a form taking 3-4 minutes to load that use to only take a few
>seconds.
>
>I've verified it is not a network problem by copying large files from
>the network server to the local hard drive from the problem PC and a
>good PC. Files copy in the same time. I also brought a copy of the
>database from the server to the local drive of the problem PC and ran
>it directly from the local PC. Still had the unacceptable response
>time - absolutely not time savings gained.
>
>I'd appreciate any help or ideas from anyone on how to troubleshoot
>this, or what the problem may be.
>
>Additional information that may be helpful follows.
>
>Thanks,
>
>LuAnne
>
>The PC system data is:
>[System Summary]
>
>OS Name Microsoft Windows 2000 Professional
>Version 5.0.2195 Service Pack 4 Build 2195
>OS Manufacturer Microsoft Corporation
>System Name MSV22847
>System Manufacturer Dell Computer Corporation
>System Model OptiPlex GX260
>System Type X86-based PC
>Processor x86 Family 15 Model 2 Stepping 7 GenuineIntel ~2391 Mhz
>BIOS Version 09/24/02
>Windows Directory C:\WINNT
>System Directory C:\WINNT\system 32
>Boot Device \Device\Harddis k0\Partition1
>Locale United States
>User Name CSC\lsloan
>Time Zone Pacific Daylight Time
>Total Physical Memory 261,112 KB
>Available Physical Memory 23,856 KB
>Total Virtual Memory 1,318,496 KB
>Available Virtual Memory 845,212 KB
>Page File Space 1,057,384 KB
>Page File C:\pagefile.sys
>
>Access information:
>
>Application name Microsoft Access
>Version 9.0
>Build 6620
>Product ID 08706-OEM-0080715-48116
>Application path C:\Program Files\Microsoft Office\Office\
>Language English (United States)
>ADO version 2.7
>VBA version 6.00
>References VBA, Access, stdole, DAO, ADODB
>Database name DailyBalancing. mdb
>Database path C:\Documents and Settings\lsloan \My Documents
>Database size 7644.0 KB
>Database create date 4/4/2006 6:49:06 PM
>Current user Admin
>Jet version 4.0[/color]

Re: Slow response on only one PC

When you split your database, did you give each user their own front end or
were they all using the same front end? If you didn't provide each user
their own FE you would experience the same problems as an unsplit db.

LSloan wrote:[color=blue]
>Hi,
>
>I have an Access application installed on a network server that is
>accessed by several users. It isn't split into a front-end/back-end (I
>know it should be but when I've tried, the response time for all users
>is unacceptable). It has been working fine for many months, for all
>users. Recently, for one user, the response time has been unacceptable
>with a form taking 3-4 minutes to load that use to only take a few
>seconds.
>
>I've verified it is not a network problem by copying large files from
>the network server to the local hard drive from the problem PC and a
>good PC. Files copy in the same time. I also brought a copy of the
>database from the server to the local drive of the problem PC and ran
>it directly from the local PC. Still had the unacceptable response
>time - absolutely not time savings gained.
>
>I'd appreciate any help or ideas from anyone on how to troubleshoot
>this, or what the problem may be.
>
>Additional information that may be helpful follows.
>
>Thanks,
>
>LuAnne
>
>The PC system data is:
>[System Summary]
>
>OS Name Microsoft Windows 2000 Professional
>Version 5.0.2195 Service Pack 4 Build 2195
>OS Manufacturer Microsoft Corporation
>System Name MSV22847
>System Manufacturer Dell Computer Corporation
>System Model OptiPlex GX260
>System Type X86-based PC
>Processor x86 Family 15 Model 2 Stepping 7 GenuineIntel ~2391 Mhz
>BIOS Version 09/24/02
>Windows Directory C:\WINNT
>System Directory C:\WINNT\system 32
>Boot Device \Device\Harddis k0\Partition1
>Locale United States
>User Name CSC\lsloan
>Time Zone Pacific Daylight Time
>Total Physical Memory 261,112 KB
>Available Physical Memory 23,856 KB
>Total Virtual Memory 1,318,496 KB
>Available Virtual Memory 845,212 KB
>Page File Space 1,057,384 KB
>Page File C:\pagefile.sys
>
>Access information:
>
>Application name Microsoft Access
>Version 9.0
>Build 6620
>Product ID 08706-OEM-0080715-48116
>Application path C:\Program Files\Microsoft Office\Office\
>Language English (United States)
>ADO version 2.7
>VBA version 6.00
>References VBA, Access, stdole, DAO, ADODB
>Database name DailyBalancing. mdb
>Database path C:\Documents and Settings\lsloan \My Documents
>Database size 7644.0 KB
>Database create date 4/4/2006 6:49:06 PM
>Current user Admin
>Jet version 4.0[/color]

--
Message posted via http://www.accessmonster.com

Re: Slow response on only one PC

Thanks for those who responded to this. I just wanted to post a
follow-up in case anyone else has this problem.

It turned out this PC had less memory than the other PCs. We ordered
and installed additional memory - it is working fine now!

LuAnne

LSloan wrote:[color=blue]
> Hi,
>
> I have an Access application installed on a network server that is
> accessed by several users. It isn't split into a front-end/back-end (I
> know it should be but when I've tried, the response time for all users
> is unacceptable). It has been working fine for many months, for all
> users. Recently, for one user, the response time has been unacceptable
> with a form taking 3-4 minutes to load that use to only take a few
> seconds.
>
> I've verified it is not a network problem by copying large files from
> the network server to the local hard drive from the problem PC and a
> good PC. Files copy in the same time. I also brought a copy of the
> database from the server to the local drive of the problem PC and ran
> it directly from the local PC. Still had the unacceptable response
> time - absolutely not time savings gained.
>
> I'd appreciate any help or ideas from anyone on how to troubleshoot
> this, or what the problem may be.
>
> Additional information that may be helpful follows.
>
> Thanks,
>
> LuAnne
>
> The PC system data is:
> [System Summary]
>
> OS Name Microsoft Windows 2000 Professional
> Version 5.0.2195 Service Pack 4 Build 2195
> OS Manufacturer Microsoft Corporation
> System Name MSV22847
> System Manufacturer Dell Computer Corporation
> System Model OptiPlex GX260
> System Type X86-based PC
> Processor x86 Family 15 Model 2 Stepping 7 GenuineIntel ~2391 Mhz
> BIOS Version 09/24/02
> Windows Directory C:\WINNT
> System Directory C:\WINNT\system 32
> Boot Device \Device\Harddis k0\Partition1
> Locale United States
> User Name CSC\lsloan
> Time Zone Pacific Daylight Time
> Total Physical Memory 261,112 KB
> Available Physical Memory 23,856 KB
> Total Virtual Memory 1,318,496 KB
> Available Virtual Memory 845,212 KB
> Page File Space 1,057,384 KB
> Page File C:\pagefile.sys
>
> Access information:
>
> Application name Microsoft Access
> Version 9.0
> Build 6620
> Product ID 08706-OEM-0080715-48116
> Application path C:\Program Files\Microsoft Office\Office\
> Language English (United States)
> ADO version 2.7
> VBA version 6.00
> References VBA, Access, stdole, DAO, ADODB
> Database name DailyBalancing. mdb
> Database path C:\Documents and Settings\lsloan \My Documents
> Database size 7644.0 KB
> Database create date 4/4/2006 6:49:06 PM
> Current user Admin
> Jet version 4.0[/color]