Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Kansas
    Posts
    1

    Unanswered: ms access invalid page fault

    In Access 97 I get "Invalid page fault in module MSACCESS.EXE at 017f: 300faf99" Then it lists lots of registers. It then shuts down Access. It happens mostly in queries and when trying to insert lookups in tables. Any help is appreciated.
    Leo

  2. #2
    Join Date
    Oct 2003
    Posts
    706

    Unhappy

    First of all, the module-name (MSACCESS.EXE, KERNEL32, etc) really doesn't tell you much.

    What does tell you something is the fact that certain things you're trying to do, consistently cause the computer to lose its cookies. The operative word is consistently.

    But... let's jump straight to "how we might fix it." Here's what I recommend:
    • "What changed recently?" Did anything happen to your computer, to your hardware, to other applications, about the same time this failure first cropped up? Is the network acting sluggish? Did you install a new software package or update? {BTW, a diary helps here.}
    • Make a copy of the database file exactly as it is right now.
    • Now, try to repair the database.
    • Also consider re-installing Microsoft Access.

    But... spend the most time on the first step, before you just "start trying things." Computers do not just start mis-behaving for no reason.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Nov 2003
    Posts
    1,487
    You might try this as well....

    Start the database while holding the SHIFT key on your keyboard. From the database window, open a code module (do not open any forms, use Design View only). From the menu, go into Debug then select Compile and Save All Modules. See if it can find a code error. A code error can cause a fault as well.

    If the code seems to be okay then go to the Forms tab on the database window. Select and Open then close each form one at a time. Remember the name of each form you open. The form that causes the Page Fault is the form with the problem in it.

    If you find the form with the problem then restart the database (while holding the Shift key) and from the database window open the form in question in DESIGN VIEW only. See if you can find the problem. You might want to try and check the Declarations Section of the form first....this is usualy where the problem lays to generate an Invalid Page Fault especially in large databases.

    If your database is linking to other tables via code, then try disabling the linking mechanism. The problem may be located in that area. Check Table Create, Table Open and Shell routines. These can also generate a Page Fault if there are code problems and error handling is turned off.

    Good Hunting...

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: ms access invalid page fault

    Originally posted by Leo Lutz
    In Access 97 I get "Invalid page fault in module MSACCESS.EXE at 017f: 300faf99" Then it lists lots of registers. It then shuts down Access. It happens mostly in queries and when trying to insert lookups in tables. Any help is appreciated.
    Leo
    Another thing you can take into consideration
    If you use object variables and set it to an object, dont forget to set it to Nothing after it finshes it role. Because if not set to Nothing, it is still in Memory, and later it would cause memory crash.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •