Application Error

[Guest]

I have Access 97 and am receiving an application error in one of my
databases. I have created a new blank database and imported all of the
objects in hopes that it will fix the problem but I keep getting the same
error. Actually there are several copies of the database that I have tried
to use and they are all displaying these errors:

The instruction at "0x77f581bd" referenced memory at "0xe6d67835". The
memory could not be "written".

The instruction at "0x77f69d63" referenced memory at "0x00000000". The
memory could not be "written".

Just so you also know, this happened on 2 different pc's. My old one and a
brand new one that I just setup last week. This PC is running both Access 97
and Access 2003. The other PC only had Access 97. The error seems to only
occur in this one database. There are only 3 public procedures and a few
public constants. There are only 3 forms with a few procedures (some open
connections to a SQL database). The error seems to be related to a simple
report based on a query that has linked SQL views/tables and resident tables.
I can open the query fine but when I click the Report button in the form,
the error displays. Even when I only go to the design view of the report, I
receive the error.

I hope someone can help me.

 

[Wayne Morgan]

While this happens on your old PC also, is the Access 97 install a new
install on that PC? If so, have you applied SR2 for Office 97 and SP3 for
Jet 3.5x? Also, the button may be corrupted. Try creating a new button and
see if that works. If so, delete the old button and use the new one.
However, since you say this happens when you go to design view of the report
also, I suspect that there is actually something corrupted in the report
itself. Is the report simple enough to recreate? Just a quick, new report
without everything being lined up perfectly would help for testing.

On a copy of the file, try opening the database in Access 2003. Does it work
there? If so, try converting back to Access 97 format (Tools|Database
Utilities|Convert Database) and see if it will work properly. Perhaps try
with and without converting. Access 2003 will open the 97 database without
converting it, you just can't make structural changes to it.

 

[Guest]

Thanks Wayne

As far as I know, it is a new install (my IT dept loaded it). I can see
that SR2 is applied to Access 97. From the ODBC Administration it looks like
I have Jet 4 rather than 3.5. I would expect that since I have Office 2003.
Wouldn't that make Jet 3.5 SP3 unnecessary?

I recreated the report and was able to work with it and click the button
that calls it on the form. However, as I was working in the form module and
public module updating some code, I recieved an "Out of memory" message. I
have never received that one before. I have a GB of RAM and 60 HD so it
isn't the hardware. I have a couple of Access 97 windows open though and
have opened and closed several database during this session.

Any other suggestions or info on Jet?
Thanks

 

[Wayne Morgan]

No, Access 97 won't use Jet 4. It would have installed Jet 3.5x when it was
installed. You will need to upgrade that to Sp3 for Jet 3.5x. You can find
your version of Jet by going to the %SystemRoot%\System32 folder and right
clicking on msjet35.dll. Choose Properties then go to the Version tab. The
version number should be 3.51.3328.0 or newer.

http://support.microsoft.com/kb/q172733/

Access 97 and 2003 should be installed in totally different directories.
Having both under Program Files is ok, but they should be different after
that. The Out of memory error make it sound as if something is corrupted.
You may want to look at this information.

http://members.iinet.net.au/~allenbrowne/ser-47.html