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

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!!
LVL 6
kerryw60Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jadedataMS Access Systems CreatorCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kerryw60Author Commented:
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
kerryw60Author Commented:
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
jadedataMS Access Systems CreatorCommented:
<Most Excellent>  thanx for the question!
0
dbarnfieldCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.