Solved

MS Access Program Errors

Posted on 1997-08-15
2
270 Views
Last Modified: 2012-05-04
I have a somewhat detailed, but not complicated database that has four or five "switchboards that have command buttons that execute various things, i.e. opening forms, printing reports, running VB modules, etc.  Every so often. I click on one of the command buttons and get an error that closes Access.  What follows is the details of two such occurances.

MSACCESS caused an invalid page fault in
module VBA232.DLL at 0137:0fa63fa8.
Registers:
EAX=0062f370 CS=0137 EIP=0fa63fa8 EFLGS=00010246
EBX=0062f3c0 SS=013f ESP=0062f278 EBP=0062f380
ECX=00460100 DS=013f ESI=00000003 FS=10ff
EDX=0062f25c ES=013f EDI=0062f364 GS=0000
Bytes at CS:EIP:
ff 56 04 eb e9 8b 44 24 04 50 8b 00 ff 50 04 c2
Stack dump:
00460100 0000000d 5008aaf2 0062f370 00681830 004421de 00400f3c 00010008       0000001a 004605cc f8a837cf 0000000a 00000000 80020004 00000000 0000000a

MSACCESS caused an invalid page fault in
module VBA232.DLL at 0137:0fb3b4e0.
Registers:
EAX=00000001 CS=0137 EIP=0fb3b4e0 EFLGS=00010246
EBX=00000000 SS=013f ESP=0062f188 EBP=0062f1e8
ECX=0062f1d4 DS=013f ESI=004600d0 FS=384f
EDX=00620003 ES=013f EDI=0062f1d4 GS=0000
Bytes at CS:EIP:
ff 50 18 8      d 4d cc 51 50 e8 a9 89 f2 ff 5f 5e 8b
Stack dump:
004600d0 000007d5 0fb4b0a8 00000409 00620003 0062f1d4 0062f494 0062f1b4       0062f1e4 0062f494 004424e2 00000000 00000000 00000000 00000000 00000000

The only way to fix, I found, was to delete the command button and create another that did exactly the same thing.  This has not been specific to one operation.  Any ideas?  This won't fly with my clients when they get random errors that renders the Access database useless.  

Thanks
Brett  
0
Comment
Question by:Brett081597
[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
2 Comments
 

Accepted Solution

by:
camgt earned 150 total points
ID: 1955669
Check the c:\windows\temp dir for .tmp files delete them.  Then run scandisk.  In most cases this takes care of the problems.  Its usually a good idea to write this procedure into the autoexec.bat file so it takes place regularly.   The only permanent solution I have found is to stop using Microcrap software.  
0
 

Author Comment

by:Brett081597
ID: 1955670
Okay, but could apply to any random error.  Anything more concrete, that is an answer, not a solution.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

622 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