Fault in MSO9.DLL

Wondering if this rings a bell for anyone...
 
 I've got a client that has an Access 2000 program that is randomly generating a fault in MSO9.DLL.  
 
 It always faults at offset 0x0007b9f2 with a 0xc0000094, which is a divide by zero error.
 
 This program has been solid for years and now is faulting for some reason. SQL Server is the backend.
 
 There are numerous apps running on this server (2008 R2) and none are having problems except this one. Nothing new or has been changed that I'm aware of.  Things I have done:
 
1. Rebuilt the DB - fresh MOB, imported tables and queries, did saveastext/loadfromtext for forms and report, and cut and pasted all code from old to new. New DB compiles fine.
2. Compacted and repaired.
3. Turned off name Auto correct.
4. Replaced the MSO9.DLL from another machine
5. Renamed MSO9.DLL and then did a repair on Office 2000.
6. Doesn't appear to be a resource problem; happens with as little as processing a few orders or a hundred and I can turn around and process the batch that just failed and it will go through fine.
 
Any thoughts are welcome.  I've been hacking away at this for about five days now and it's driving me nuts.
 
Jim.
LVL 59
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAsked:
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.

Gustav BrockCIOCommented:
How about a reinstall of Office 2000 after having removed it completely (MS has a Tool for this: Eraser2k.exe).
Also a clean-up of the Registry and temp files. We use CrapCleaner for this.

/gustav
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
gustav,

  I've been thinking about a full re-install, but have been hesitant...no other app is having any kind of issue.

  It could be that the Access install is broken and that only this application is hitting something the others do not, but it's a long shot.

  It basically is doing what other programs are doing and there is nothing unique in terms of it's processing except for handling CC processing, which is done with a reference set to Microsoft XML, ver 6.0.  That code however is not being used or called at this point and hasn't been for a few years.  It was in-place before this started to happen.

 Just to be sure though, I think what I'll do is comment out the code and remove the reference.  You also mentioned temp files, which I meant to clear and forgot about.

 Really odd problem.    This will go on my all-time top ten Access problem list.   Never have seen anything like it.

Jim.
0
Gustav BrockCIOCommented:
OK, seems like commenting out that code is a place to continue testing.

/gustav
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
I believe I found the cause of this, which was DEP (Data Execution Prevention).   Since disabling on the server, I have not had a single fault.

Jim.
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
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
Found answer myself.
0
Gustav BrockCIOCommented:
So the app runs on the server?

/gustav
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerAuthor Commented:
Yup.   Since turning off DEP, it hasn't faulted once.   I had turned off DEP for Access when they first moved onto this server and apparently a Microsoft security updated turned it back on.

Jim.
0
Gustav BrockCIOCommented:
OK.

/gustav
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.