Charlotte Foust
cfoust at infostatsystems.com
Wed Jun 18 17:54:40 CDT 2003
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