MS Access database support - Slow response on only one PC

Author

Slow response on only one PC

LSloan

2006-04-05, 3:30 am

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 Microso
ft 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\s
ystem32
Boot Device \Device\Hardd
isk0\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

Tom van Stiphout

2006-04-05, 9:35 am

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:
http://www.granite.ab.ca/access/performancefaq.htm

-Tom.

>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 Microso
ft 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\s
ystem32
>Boot Device \Device\Hardd
isk0\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

jahoobob via AccessMonster.com

2006-04-05, 9:35 am

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:
>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 Microso
ft 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\s
ystem32
>Boot Device \Device\Hardd
isk0\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

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

Sponsored Links