Access 97 memory error

[C Reece]

We have a 97 database that's located on a server, with many people accessing
to enter data. When I try to design or run existing reports, I have about a
70% chance of encountering an Application Error that says "The instruction at
0x77f5f30c referenced memory at 0x09420000. The memory could not be read."

This happens whether I'm using the main database, or if I make a copy and
move it to my computer and try to design or run the reports.

I've also tried deleting and re-creating the reports, but that doesn't make
a difference, either.

A number of the users can print their reports each day, but there are a few
that consistently run into the same type of error.

I got a completely new computer yesterday - new hardware, new software
image, etc., so that doesn't seem to be the issue.

We're transitioning to 2000 in a month, and to 2003 by the end of the year,
but I need to get these reports working NOW!

The only related tip I could find said "your computer is having memory
errors - try rebooting." This does not fix the problem for me.

Any other ideas / help / solutions ..... please!

Thanks

 

[strive4peace]

Hi C

'~~~~~~~~~ Decompile ~~~~~~~~~

try decompiling the database

make an icon with this as its target:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\path\filename.mdb" /decompile

if your Access program is not located in the directory specified, make
the appropriate substitution

after you decompile, compile it if you have any code and then do
compact/repair

'~~~~~~~~~ ~~~~~~~~

you can also make a "generic" decompile icon where the next database you
open will be decomipled...

ie:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /decompile

Have you COMPILED it?

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code or references, your should always compile
before executing.

from the menu in a module window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)



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

 

[C Reece]

Thank you Crystal,

After several errors today, it suddenly started working with no further
errors (knock wood). I appreciate your suggestion, and I'll try it if it
happens again (I hope I don't have to).

The original programmer insists that it's a hardware issue, and after
replacing my computer and not having the problem resolve, the IT guy insists
that it's the original programmer's issue. Hah!

Thanks again!

Carla

 

[strive4peace]

you're welcome, Carla

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