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 3 6539
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\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
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\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
--
Message posted via http://www.accessmonster.com
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\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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: j askey |
last post by:
I have a strange bandwidth issue that I have finally tracked down to
something fairly specific if anyone has any ideas...
Setup: Win2003 Server, PHP 4.3.4, IIS6.0, ISAPI
Network: DSL line with a Cisco 678 router using NAT and static port
maps. Two switches between webserver and Cisco.
Problem: Accessing PHP driven site via any computer except the web
server is about 20 times slower. I can get fast response on the server
|
by: Shay |
last post by:
essentially I am trying to do some counts based on some
assumptions in the recordset. So I get the RS back, put
the values into a variable, move to the next record in the
RS and compare what is in the variable to the value in the
next record in the recordset and do a count. Then
overwrite the value in the variables and do the same for
the next record and so.
But this runs extremly slow. 5000 records takes about 10
minutes in IE6 and I...
|
by: Kurt Bauer |
last post by:
I have an ASP group calendar application which pulls calendar data from
Exchange via webdav into an XML string. I then loop the XML nodes to
populate a collection of appointments. Finally I use the appointment
collection to populate the calendar control. The performance getting the
XML data is fine, but loading the data into the collection is slow. My
question/problem is should I be using the collection, a dataset, or
something else to...
|
by: BlueBall |
last post by:
I am writing some kind of network testing tool and I have wrote the
following code in ASP.NET with C#
int size= 10048576; // around 10 MB data
string buffer = "";
for (int j=1; j<=1024; j++) {
buffer = String.Concat(buffer, "x");
// I tried buffer += "x"; same performance
}
|
by: Vito DeCarlo |
last post by:
Over the past week, I've been noticing that any websites (on this one
particular web server) built with ASP.NET have unusually slow (5 second)
response times when moving through the site. There are times when the
delays dissappear, but they are existent 80% of the time.
This has only started up over the past week or so and I have checked CPU
usage, memory usage, etc. I've also reinstalled the 1.1 version of the .NET
framework just to...
| |
by: Buddy Ackerman |
last post by:
I'm trying to write files directly to the client so that it forces the client to open the Save As dialog box rather than
display the file. On some occasions the files are very large (100MB+). On these files teh time that it takes until the
client displays the Save As dialog can be extrordinarily long (3+ minutes). I don't understand why.
I was initiall using the format:
Respnse.writefile("filepath", offset, length)
but that simply...
|
by: MadMan2004 |
last post by:
Hello all!
I'm having a problem with a project I'm working on and I'd like to ask
for anyone's input that might be helpful. I'm building a rather large
front-end application connecting to an AS400 for the back end database
and I'm experiencing slow response times when executing sql statements.
Some select statement response times are bad. Not all, but some. And
there doesn't seem to be a consistent factor in any of the sql
statements...
|
by: SAL |
last post by:
I have an ASP.NET 2.0 app that takes about 17 seconds to load on first
startup but then is very fast after that. As I understand it from some posts
in June, this is caused by the loading of the App Domain.
We have both Cold Fusion and ASP.NET apps on this server and the Cold Fusion
apps do not display such slowness on their first start up of the day. Is
there a way to improve the load times of ASP.NET apps?
I'm having to justify to my boss...
|
by: gnomee2 |
last post by:
Hello Everyone,
I have a strange problem that I cannot seem to solve. I have two server running Windows 2003 MSSQL on one IIS on the other.
Out of the blue I have slow queries that cause asp script timeouts and I cannot figure it out. I have moved some test code to other sites on the server and still have these long delays.
I have tried dropping the tables, then the database entirely and restoring and still slow. I run the same code on...
|
by: John |
last post by:
Hi
I have replaced an ms access app with its vb.net version at a client site.
Now the clients keeps complaining about how slow the app response is. The
complains they have are for example when app is minimised and then trying to
maximise it after a while takes a while for app to get maximised. Also form
painting of controls is slow and app is generally slow in terms of response
to user clicks. I am using Infragistics controls and my...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |