?
Solved

Access97 crashes with VBA332.dll fault c0000005

Posted on 1998-08-19
7
Medium Priority
?
998 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 150 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

770 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