Solved

Access97 crashes with VBA332.dll fault c0000005

Posted on 1998-08-19
7
982 Views
Last Modified: 2012-08-14
I'm having a problem with MS Access.
The nearest I can trace it the problem started after modifying the file layouts (added 1 field to 2 files) in my 'attached' data.mdb.
Now, when I try to log into my code.mdb I get the following:
MSACCESS.EXE caused fault #c0000005 in VBA332.DLL at address 0177:6517daaa

(Or, from newly downloaded version of VBA332.DLL)
MSACCESS.EXE caused fault #c0000005 in VBA332.DLL at address 0177:65182a15

I can also load without running my code.mdb but as soon as I try to run a form I get the same error.

VBA332.dll appears to be some sort of Access to VBA interpreter or interface which has appeared to have slipped a cog.

Anyone heard of this? Any known solutions?

Thanks,
jimsha
0
Comment
Question by:jimsha
7 Comments
 
LVL 2

Expert Comment

by:danyell
ID: 1959670
Have you ever gotten this MDB-pair to work?

If so, try refreshing your table links using the "Attached Table Manager" in the Add-Ins menu. Then try opening the form again. Also try compacting both MDBs. I've had crashes like yours (except connecting to SQL Server) that went away after compressing the "client" (your Code) MDB file.

If not, have you installed any new software recently? An unbelievable number of products (not all from Microsoft) rely on various VB DLLs. What version of VBA332.DLL do you have, what's the file date and where is it stored?

Mine is v3.0.7019, size: 1,597,200 bytes, dated 7/11/97 12:00 AM, located in "C:\Program Files\Common Files\Microsoft Shared\VBA."

0
 
LVL 9

Accepted Solution

by:
perove earned 50 total points
ID: 1959671
This could be several reason for theis. There are info collected in one page:
Troubleshooting Invalid Page Faults in MS Access 95 and 97


Look at:http://support.microsoft.com/support/kb/articles/q148/4/24.asp
perove

0
 

Author Comment

by:jimsha
ID: 1959672
It took a day but, after repairing, compressing, reattaching, upgrading vbx332.dll...,  I got into re-compiling and crashed. Decided to import everything (>2000 objects) into a new, blank mdb. This crashed on a specific MODULE. So I imported everything but that. Them got that from a backup. I hadn't made any changes to that code so I didn't loose anything but have no idea why it got corrupted.
That is a good reference as it helps cover all bases in a case like this.
Thanks.
jimsha
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:jimsha
ID: 1959673
danyell, thanks. See note to perove above.
0
 

Expert Comment

by:jrk
ID: 1959674
The database in question was probably compiled using resources that, in your present system, have changed. Meaning: If you compile/save the MDB file and then install a program (from microsoft or where ever) that updates certain VBA component DLL's, the entry points to the resources may or may not coincide to the database's list. What you need to do is decompile the MDB file and then recompile it. You do this by adding the switch "/decompile" in the command line when you open the database. When you recompile the database, the database then attains the new entry point list from Access. The resources that the database refer to are then in sync. That would be the reason why when you import all the objects into a new database it usually solves the problem. I hope this helps. But there is no question that the page fault is a resource entry point problem.
0
 

Expert Comment

by:ABE2276
ID: 1959675
I do probably know a "partial" way to solve a problem:

  that mistake occurs because (in my sitiation) MSA'97 compiles
  the code You're usin' in You module(s). That applies to any
  API using functions and procedures (such as RegKeyOpenEx).
  You can fix (or just bypass) the bug, when using  Norton
  CrashGuard (NCG) (part of NU'98 toolkit). That program is
  a TSR, which detects system faults and tries to correct them,
  before Windows shows You a fatalerrorwindow. In my case, i've
  launched a corrupt database, NCG detected a mistake and
  stopped the compiling, asking if i could proceed without it.
  By answering Yes i've got my database open and functionable.
  Just a remark: delete the function You think caused a mistake
  or rebuild it.

Just do it
 
0
 

Expert Comment

by:asecguy
ID: 1959676
If your file vba332.dll has a date of 11/20/96 or older, this is probably your problem.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

831 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