Re: Very slow response

Simon

If you open a new Access database, select Tools, Options ... one of your
settings tells Access where to start looking. Is there a chance that option
has been set to something on the LAN?


--
Good luck

Jeff Boyce
<Access MVP>
"Simon Wong" <SimonWong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29150C41-B1BE-4698-B4E4-31F1F8F749DC@xxxxxxxxxxxxxxxx
> Dear Jeff
>
> Thank you for your reply. Herebelow is some more features of my problem.
>
> My database file is on my local drive, c:\data\database.dbl
> My Access 2003 is also on my local drive.
>
> The problem comes when
> My LAN connection is on
> I entered Access, open the database file
> Then I load a report and it response very slowly
> I note the program is surfing over LAN looking for something as the
network
> icon in the right lower coner flashes, and when it stop flashing the
program
> response
> Then I enter the report's design view to edit the report layout
> Then for every keystroke typed I need to wait say 15 sec for a response
and
> the LAN icon flashes.
> Then I close the Report
> Then turn LAN off
> Then I can never open the report file again.
>
> Then I close the database file
> And then close the Access program
> When LAN is still off
> I re-open the Access program
> Open the database file
> Go the report and load a report
> The program response very speedy and the above problem is gong.
>
> The above happens also to the Northwind sample database so that when LAN
is
> on, response is slow and the program repeatly surf the LAN, and when LAN
is
> off, problem gong.
>
> The above still happens when I disable the Norton antivirus on my
computer,
> which suggest that the problem is not related to the antivirus program
>
> Meantime the following background info might shed some light to the above
> issue.
>
> At the very beginning the database file is located on a Server
> And I access the file, do editing, on my own old computer via LAN
connection
> (Access 2000 over Win98 Trad Chinese)
> I purchased a new computer last weekend (WinXP installed Access 2003)
> I move the database file to my new computer's local drive in order to have
> direct access.
> The above problem comes.
>
> It appears that a BAD HABBIT is planted on my access programe that
whenever
> LAN is on it will surf the LAN first even the database file is located on
the
> local drive.
>
> Grateful if you can help me out.
>
>
> Best regards
> Simon
>
>
>
> "Jeff Boyce" wrote:
>
> > Simon
> >
> > A couple possibilities come to mind...
> >
> > A "new, improved" (or updated) network antivirus installation caused a
> > similar slow-down in one of my installations.
> >
> > From your description, it almost sounds like the report definition you
are
> > working on is located on the network. If you are working with a split
> > database, is the report definition in the front-end or the back-end?
> >
> > --
> > Good luck
> >
> > Jeff Boyce
> > <Access MVP>
> >
> > "Simon Wong" <SimonWong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:C52A2733-CE1B-4593-8E16-819AAD6E8BA9@xxxxxxxxxxxxxxxx
> > > Simon Wong again
> > >
> > > Just found if I disable the network connection
> > > I cannot open any report
> > > It seems that the program is "MARRIED" to network connection.
> > >
> > > Hope someone can help me out.
> > >
> > > Simon Wong
> > >
> > >
> > > "Simon Wong" wrote:
> > >
> > > > When I open a report's design view
> > > > It response very very slowly
> > > > I discovered that the network icon at the right end corner glow for
few
> > > > seconds
> > > > seems some network activity going on and
> > > > The program response only after the network item turns off
> > > > But when I triger any action, the network icon glow again and I have
to
> > wait
> > > > before I can move to next action.
> > > > It has hamper my report design job.
> > > > The problem does not exist in Table, Query and Form
> > > >
> > > > My system is :
> > > > Access 2003 (English) on WinXP (Trad Chinese)
> > > >
> > > > I have been working on Access for few years and have not come across
> > this
> > > > situation before. Hope someone can help me to tackle this.
> >
> >

.

Relevant Pages

  • Re: Very slow response
    ... I entered Access, open the database file ... I note the program is surfing over LAN looking for something as the network ... Then I enter the report's design view to edit the report layout ...
    (microsoft.public.access.reports)
  • Re: Very slow response
    ... > has been set to something on the LAN? ... >> I entered Access, open the database file ... >> Then I load a report and it response very slowly ... >> Then I enter the report's design view to edit the report layout ...
    (microsoft.public.access.reports)
  • Re: Very slow response
    ... >> has been set to something on the LAN? ... >> Jeff Boyce ... >>> I entered Access, open the database file ... >>> Then I enter the report's design view to edit the report layout ...
    (microsoft.public.access.reports)
  • Re: One Form Linked to Multiple Databases
    ... every time the company program completes an order it creates ... >a new database file for that specific order (i.e.: ... If their assumption is that you can only view a report on data if the ...
    (microsoft.public.access.forms)
  • RE: updated numbers in report
    ... for making an input to the database. ... textbox will be located alongside with the combobox where the belonging ... belonging query for the report. ... ElapsedTime([Date First Time Onboard], ...
    (microsoft.public.access.dataaccess.pages)