Unhandled exceptions during report outputs to snapshot files

[strive4peace]

Hi Peter,

you're welcome

Since Graph should close before you do another report, you may want to
loop until that has happened...

Find out if an application is currently running, by Dev Ashish
http://www.mvps.org/access/api/api0007.htm



Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

Hi Peter,

did you get it resolved? ... just checking in!

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[Peter B]

Crystal,

No resolution yet, inspite of putting a 3 second delay loop between
reports. But, I could try your suggestion about waiting for all
instances of GRAPH to be gone. I haven't looked at what you sent me,
but I'm guessing it's a WMI approach (??). We'll see. I've programmed
that before in VB Script to query the process list to see if something
is running.

I'll give that a try.

 

[Peter B]

Crystal,

Just implemented the "make sure GRAPH.EXE instances are gone before
proceeding to next report" + a 3 second delay between report exports,
and I still got the bomb. Didn't take long to manifest (#!@*&^!).

This is worth mentioning. I have two other types of reports that I
generate as part of this process. One has no OLE objects embeded,
while the other does (charts). Neither of these reports give me any
trouble, and I export thousands of snapshots for this.

The report with the problem is composed of 4 sub-reports. I call it a
combo report. In the combo report, two of the sub-reports are the ones
I mention above, including the one with the embeded OLE chart. What's
strange is that the combo report (which will not work correctly) is
composed of other reports that, individually, work fine. The VBA code
that runs when I export the individual reports also runs as part of the
combo report.

I can control which reports get exported. When I EXCLUDE the combo
report, I don't have any problems. Any time the combo report is part
of the process, chances are high that I'll have this problem.

So, I just don't understand what the problem is, unless the combo
report is simply too complicated for Access. I have diligently been
sending the error reports to MS, and I just wish someone would pay
attention. But, I'm not holding out hope.

Sigh.

 

[strive4peace]

Hi Peter,

rather than just looping for a time, put the check to see if Graph is
still open in your loop -- and let that be your determining factor for
moving on...

Also, you do not want to just loop on DoEvents... too many DoEvents is
not such a good thing ... check to see if Graph is done, do a complex
calculation -- or just count to some number whose variable you set --
check Graph, etc

"I haven't looked at what you sent me, but I'm guessing it's a WMI
approach (??)."

here is some info on API:

http://en.wikipedia.org/wiki/API

and a little bit from the top:

"An application programming interface (API) is the interface that a
computer system, library or application provides in order to allow
requests for services to be made of it by other computer programs,
and/or to allow data to be exchanged between them." ... and so on...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

Hi Peter,

how much memory do you have?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[strive4peace]

Hi Peter,

added note:

My machine has 1.5 GB DDR memory, 2.8GHz Intel processor, running Access
2003 under XP Pro SP-2 but Tom ran it on older machines...

Tom said, "I've been thinking that what he might need is an older PC to
run his mega-snapshot generation code on. After all, I've tested it on
two PC's without any failure. My PC is 5 years old, and my step-dad's is
4 years old. So, they are not the speed demons they once were,
especially since they're running fairly new software (Windows XP Pro.
SP-2 / Office 2003 with SP-2) that has a lot more lines of code in it
than Windows 2000 / Office 2000 likely had 5 years ago (more lines of
code ---> slower running, especially for older machines [aka bloat code])."

If you have plenty of RAM, another question I have is this: have you run
spyware checkers such as Ad-Aware, Spybot, etc lately? What else is
running that may be taking your resources?

What version of Access are you using?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

 

[Tom Wickerath]

Hi Crystal & Peter,

My 5-year-old PC, which uses the Windows 2000 Server operating system with
Access 2003, SP-2, has a measly (by today's standards) 512 MB of RAM. The
processor is a AMD K7 1.2ghz. I think (although I'm not positive) that my
stepdad's PC also has 512 MB of RAM. His processor speed is a bit faster,
since his PC is one year newer than mine.

Now you know why I haven't attempted to load Vista / A2007 beta, <smile>
since my system isn't "good enough" to support Virtual PC (and I refuse to
load beta software on a system that is working perfectly well right now,
thank you).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[strive4peace]

Hi Tom,

here is what I did to load the beta (it is running under XP SP-2) and it
seems to be working very well

1. get another drive (and more memory too if you can since that is the
cheapest thing you can do to increase performance)

2. unhook the cables on your current drive and hook up the new drive

3. install Windows and then the beta on the other drive

4. then, hook your first drive back in -- use it for your work

5. when you want to use the Beta version, go into the BIOS menu (ie:
press DELETE when your computer boots) and change the boot drive. Change
it back again to do your work.

My son loaded Vista yesterday on another drive in his computer (and we
do the BIOS drive switching thing for that too) ... from what he has
said, I think I will stick with XP for awhile -- among other things, it
seems to be menu-cumbersome. On a positive note, it was very easy to
connect to the Internet...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*

Hi Crystal & Peter,

My 5-year-old PC, which uses the Windows 2000 Server operating system with
Access 2003, SP-2, has a measly (by today's standards) 512 MB of RAM. The
processor is a AMD K7 1.2ghz. I think (although I'm not positive) that my
stepdad's PC also has 512 MB of RAM. His processor speed is a bit faster,
since his PC is one year newer than mine.

Now you know why I haven't attempted to load Vista / A2007 beta, <smile>
since my system isn't "good enough" to support Virtual PC (and I refuse to
load beta software on a system that is working perfectly well right now,
thank you).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

Hi Peter,

added note:

My machine has 1.5 GB DDR memory, 2.8GHz Intel processor, running Access
2003 under XP Pro SP-2 but Tom ran it on older machines...

Tom said, "I've been thinking that what he might need is an older PC to
run his mega-snapshot generation code on. After all, I've tested it on
two PC's without any failure. My PC is 5 years old, and my step-dad's is
4 years old. So, they are not the speed demons they once were,
especially since they're running fairly new software (Windows XP Pro.
SP-2 / Office 2003 with SP-2) that has a lot more lines of code in it
than Windows 2000 / Office 2000 likely had 5 years ago (more lines of
code ---> slower running, especially for older machines [aka bloat code])."

If you have plenty of RAM, another question I have is this: have you run
spyware checkers such as Ad-Aware, Spybot, etc lately? What else is
running that may be taking your resources?

What version of Access are you using?

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com

 

[Tom Wickerath]

Hi Crystal,

Step 5 should not be necessary. You can configure what is commonly known as
a "dual boot" or "multiple boot" configuration. In Windows 2000, see the help
topic titled "Installing more than one operating system on your computer".
I'm not sure if it is listed under the same topic in WindowsXP, since I'm not
using WindowsXP on my main PC (I do have it on my laptop PC, but that's
currently in the Baltimore area with Cindy).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[strive4peace]

thanks, Tom, I'll have my son (the hardware expert in the family )
check into it

I was going to set up a virtual computer, but it was recommended to get
2 drives, so I saw no need...I can access all the files from either
drive anyway

I just recently switched to XP myself -- was using ME till a storm
rearranged my hard drive

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*