[AccessD] Access 97 causing CPU useage 100% in W 2000

Tortise@Paradise tortise at paradise.net.nz
Wed Jun 18 18:36:24 CDT 2003


Kewl
I tried the solutions model and found it to be unreliable.
With the current setup record locking does occur, but is managed fine manually.
One has a desktop shortcut with a different Ctrl Alt Key shortcut set to quickly multitask between the instances.
If I can do this within Access then that would be great!
Does someone else have a working model, thats reliable, that they'd be prepared to share?
Kind regards,
David Hingston
_________________________________________________________________________
mailto:tortoise at paradise.net.nz
Personal Webpages: http://203.79.82.163/
http://www.engines2go.com/   Now THAT's a Search Engine!!
Simultaneously opens multiple search engine windows to rapidly find what you seek.   Works before your eyes
ALT-TAB between windows. Its FAST.  Its Exciting!  It works for you.  Have you tried it yet?
Home of Break Reminder, Clipboard Express, MP3 Detective and TimesOwn: http://www.cheqsoft.com/
----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, June 19, 2003 10:54 AM
Subject: RE: [AccessD] Access 97 causing CPU useage 100% in W 2000


No, that's what I understood you to be saying.  The problem is that each
session of Access is hogging as much RAM as it can get and unless you
have a LOT of RAM, sooner or later it will cause you trouble.  Not to
mention that in A97, you're stuck with page locking, so you can wind up
locking yourself out of records.

You can launch multiple instances of a form by treating it as a class
and doing some fancy coding (there are examples in the Solutions
database for A97), but again, if you get specific about what you need to
do, someone should be able to help.  Littering the landscape with
instances of Access won't do a thing for CPU problems.

Charlotte Foust

-----Original Message-----
From: Tortise at Paradise [mailto:tortise at paradise.net.nz] 
Sent: Wednesday, June 18, 2003 2:43 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access 97 causing CPU useage 100% in W 2000


Woops
Sorry I mean't to say multiple instances of the SAME form.
It is a contact management database.
Opening several instances of access allows one to multitask between the
databases instances and stay in the same place on each form in the
separate windows. Can one do this within one database easily? Kind
regards, David Hingston
________________________________________________________________________
_
mailto:tortoise at paradise.net.nz
Personal Webpages: http://203.79.82.163/
The Mother of All Search Engines.  http://www.engines2go.com/
Simultaneously opens multiple search engine windows to rapidly find what
you seek.   Works before your eyes
ALT-TAB between windows. Its FAST.  Its Exciting!  It works for you.
Have you tried it yet? Home of Break Reminder, Clipboard Express, MP3
Detective and TimesOwn: http://www.cheqsoft.com/
----- Original Message -----
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, June 19, 2003 10:28 AM
Subject: RE: [AccessD] Access 97 causing CPU useage 100% in W 2000


Excuse me?  Running multiple sessions is NOT easier and more reliable
than coding multiple forms and you run the risk of stepping all over
yourself.  Maybe you should describe what you're doing in more detail.

Charlotte Foust

-----Original Message-----
From: Tortise at Paradise [mailto:tortise at paradise.net.nz]
Sent: Wednesday, June 18, 2003 2:19 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Access 97 causing CPU useage 100% in W 2000


It comes up when running multiple instances of the database, (Easier and
more reliable than coding multiple forms - at least when I tried, in the
days of ++RAM and CPU) and just seems to take over CPU use for long
periods.  (Beyond the CPU one would see with opening a database or doing
a large query)  It just doesn't stop. Shutting em down stops it
though... Is it possible to focus on the processes Access is running
somewhere? Kind regards, David Hingston
________________________________________________________________________
_
mailto:tortoise at paradise.net.nz
Personal Webpages: http://203.79.82.163/
The Mother of All Search Engines.  http://www.engines2go.com/
Simultaneously opens multiple search engine windows to rapidly find what
you seek.   Works before your eyes
ALT-TAB between windows. Its FAST.  Its Exciting!  It works for you.
Have you tried it yet? Home of Break Reminder, Clipboard Express, MP3
Detective and TimesOwn: http://www.cheqsoft.com/
----- Original Message -----
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, June 19, 2003 10:03 AM
Subject: RE: [AccessD] Access 97 causing CPU useage 100% in W 2000


Depends on what you're seeing and when.  Normally Access uses the
available resources but releases them when another process needs them.
I've seen all versions of Access grab the CPU, not let go, and become
generally unresponsive, not just A97.  Vanilla A97 had a known problem
with dual processors, and installing SR-2 is one of the suggestions to
cure this.  A different problem can crop up in synchronizing replicas
and that one is cured by changing the MaxLocksPerFile registry setting.


Charlotte Foust

-----Original Message-----
From: Tortise at Paradise [mailto:tortise at paradise.net.nz]
Sent: Wednesday, June 18, 2003 1:43 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Access 97 causing CPU useage 100% in W 2000


Hi
Can anyone give me some pointers how I might track down this problem? Is
there some facility which tells me what Access is doing and where the
problem might lie? Kind regards, David Hingston
________________________________________________________________________
_
mailto:tortoise at paradise.net.nz
Personal Webpages: http://203.79.82.163/
The Mother of All Search Engines.  http://www.engines2go.com/
Simultaneously opens multiple search engine windows to rapidly find what
you seek.   Works before your eyes
ALT-TAB between windows. Its FAST.  Its Exciting!  It works for you.
Have you tried it yet? Home of Break Reminder, Clipboard Express, MP3
Detective and TimesOwn: http://www.cheqsoft.com/


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list