Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Access Program Errors

Posted on 1997-08-15
2
Medium Priority
?
272 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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.
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: …
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…

715 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