[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Fault in MSO9.DLL

Posted on 2014-07-14
8
Medium Priority
?
376 Views
Last Modified: 2014-07-26
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.
0
Comment
  • 4
  • 4
8 Comments
 
LVL 52

Assisted Solution

by:Gustav Brock
Gustav Brock earned 1000 total points
ID: 40196343
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
 
LVL 58
ID: 40196674
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
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 40196690
OK, seems like commenting out that code is a place to continue testing.

/gustav
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 0 total points
ID: 40219182
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
 
LVL 58

Author Closing Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
ID: 40219187
Found answer myself.
0
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 40220949
So the app runs on the server?

/gustav
0
 
LVL 58
ID: 40221302
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
 
LVL 52

Expert Comment

by:Gustav Brock
ID: 40221828
OK.

/gustav
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

834 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