Solved

The instruction at ... referenced memory at ... The memory could not be "read."

Posted on 2003-11-26
5
60,613 Views
Last Modified: 2012-05-04
Error Message: The instruction at ... referenced memory at ... The memory could not be "read."

This is happening in an Access97 database on Windows NT. Here is a list of what has happened and what I've tried so far:

1) It happened on a single pc. The person was given a new pc and Norton Ghost was used to put his stuff on new pc. The problem continued on the new pc. (Note: This same program is on more than 100 other systems with no problem.)

2) Tried Compact and Repair.

3) Gave him a new copy of the application just to be certain the app wasn't corrupt.

4) Uninstalled all Office97 products and reinstalled.

5) Made certain service packs were installed.

6) Put mdb version of application on this pc and followed the code line by line. "Seems" to always happen at a DoCmd.OpenQuery command in code, but not every time it hits a line of code that has DoCmd.OpenQuery (about every other time).

7) Have been able to successfully run other Access97 apps through that same type of code, but they don't give the error message and shut down.

8) And, just for the heck of it, I created a blank Access97 database and dumped the old mdb into a new database, then created a new mde.

I would appreciate any help or suggestions. This is the day before Thanksgiving, so I may not check back until Monday morning. THANKS!!
0
Comment
Question by:kerryw60
  • 2
  • 2
5 Comments
 
LVL 32

Accepted Solution

by:
jadedata earned 500 total points
Comment Utility
Hey kerryw60!

This is not an Access instruction that the message refers to this is a low level memory read error from windows.
If this is happening predictably it could be:
  1.  a bad memory module.
  2.  A conflict with another dll or ocx control trying to compete for the same memory area.
 
If you have Dr Watson running and trapping errors, you can gain some additional insight into what is happening at the "moment of impact"

regards
Jack
0
 
LVL 6

Author Comment

by:kerryw60
Comment Utility
Hi Jack,
I think I can rule out "a bad memory module" as it happened on the second pc after using Norton Ghost to copy hard drive from first pc. I'm not familiar with Dr Watson, but will give that a try. Thanks for the suggestion. Will let you know how it goes.
0
 
LVL 6

Author Comment

by:kerryw60
Comment Utility
Hi Jack,
I'm not physically at the location and have to rely on an IT group, none of which can get Dr. Watson to run, including someone that's MS certified in NT. Everyone is giving up on this problem and going to put a new box in place to run this one program (no ghosting this time). Since you were the only one to post a suggestion, I'll give you the points. I also believe that you are right. I looked at Dr. Watson on my own pc and found it can provide some useful information.

Thanks,
Kerry
0
 
LVL 32

Expert Comment

by:jadedata
Comment Utility
<Most Excellent>  thanx for the question!
0
 

Expert Comment

by:dbarnfield
Comment Utility
If you get it when you try to preview or print a report it may be a conflict with your print driver - I had the problem with Access 2000 and  my HP Laserjet 4200 on Win 2000. Try getting the latest driver.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now