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:
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
.

Relevant Pages

  • Slow response on only one PC
    ... I have an Access application installed on a network server that is ... Recently, for one user, the response time has been unacceptable ... The PC system data is: ... Access information: ...
    (comp.databases.ms-access)
  • Data disappearing - without apparent cause
    ... to store the merged documents in different places on their PC's (or ... even on the network server where the BE is), ... fields is actually local to the FE part of the database, ... Note that it is not envisaged that users will change the folder ...
    (comp.databases.ms-access)
  • Re: Multi-user Database Set Up
    ... I wonder if this might be my problem, I have one access mdb file, that is on ... a network server and when two or more people are opened on the file, ... linked to a front-end to prevent this from happening. ... the database into a front-end (containing the queries, forms, reports, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Read/Write permissions in MS Access
    ... >I have a Database which is on a Network server. ... > are attached to the server you have all the permissions, ... The easiest way would be to implement user level security but give read ... permissions for all database objects to the "users" group. ...
    (microsoft.public.access.security)
  • Re: j:(my File).mdb is not a valid path. Make sure the path name is
    ... Neil ... > j:\.mdb is not a valid path. ... > There are only two files on the network server. ... > the database. ...
    (microsoft.public.windowsxp.help_and_support)