Solved

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

Posted on 2003-11-26
5
60,717 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
ID: 9827265
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
ID: 9850519
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
ID: 9875109
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
ID: 9875145
<Most Excellent>  thanx for the question!
0
 

Expert Comment

by:dbarnfield
ID: 10260838
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Can not open the Access Help ? 3 53
Passing variables to a function 6 34
VBA Access 2016 syntax 6 41
Dcount using a date in a table compared to today's date 3 29
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

785 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