1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

MS Access 2000 crashes

Discussion in 'Other PC Software' started by ramon82, 2008/10/21.

  1. 2008/10/21
    ramon82

    ramon82 Inactive Thread Starter

    Joined:
    2008/08/07
    Messages:
    66
    Likes Received:
    0
    I am having a problem with MS Access. It sometimes crashes and returns these errors: http://img518.imageshack.us/my.php?image=20630948ic9.jpg

    Has anyone got some ideas? I reinstalled Office from scratch and even performed a clean install of Windows XP to no avail :(
     
  2. 2008/10/21
    Steve R Jones

    Steve R Jones SuperGeek Staff

    Joined:
    2001/12/30
    Messages:
    12,315
    Likes Received:
    252
    You can Google the Run-Time Error....

    "Runtime Error 91: Object variable or with block variable not set" error with Microsoft Message Queuing Triggers
    http://support.microsoft.com/kb/327245
     

  3. to hide this advert.

  4. 2008/10/21
    Bilb0

    Bilb0 Inactive

    Joined:
    2007/07/23
    Messages:
    203
    Likes Received:
    6
    OK, you can't get to the second error without first encountering the first error.
    The second error is very common, and is exactly what it says :Variable not defined.

    The variable is probably defined at, or just after the point where the first error is encountered.

    Could not lock file could EASILY be followed by one or more code steps to access data within the file and then define variables from it.
    Hence, when the code is reached which uses the variables, you will get the variable not set error(s).

    For purposes of expediency, I'll assume the database you're opening, is a "front-end" which accesses other (back-end) databases for its functionality.

    There are numerous different methods access can make use of data from other databases, but the bottom line is, it must be successful.
    If you could shed some light on what this front end does, or the types of databases to which it connects, and your network, etc, I might be able to shed some additional light on it.
    Here is but one example:
    http://support.microsoft.com/kb/305995/en-us


    Also, and this is VERY important:
    Vista does NOT like many of the data access methods permissable within Access 2000.
    If you have just recently installed this database on a Vista system, whereas the same code functioned properly on an earlier OS, you may not be able to resolve the issue without upgrading the database and changing some of the code.

    One other thing, has this database been compiled into a MDE? if so, you cannot modify the code. Any solution would have to be external to the code.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.