|
P: n/a
|
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\system32
Boot Device \Device\Harddisk0\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
| |
Share this Question
|
P: n/a
|
On 4 Apr 2006 19:08:16 -0700, "LSloan" <ls******@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 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\system32
Boot Device \Device\Harddisk0\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 | |
|
P: n/a
|
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 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\system32
Boot Device \Device\Harddisk0\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.accessmonster.com | |
|
P: n/a
|
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: 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\system32
Boot Device \Device\Harddisk0\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 | | This discussion thread is closed Replies have been disabled for this discussion. | |  Question stats - viewed: 5939
- replies: 3
- date asked: Apr 5 '06
|
