Solved

MS Access Program Errors

Posted on 1997-08-15
2
268 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

763 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