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
Solved

MS Access Program Errors

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

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.

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…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

860 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