Solved

MS Access Program Errors

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

758 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now