Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Error in Conversion Access 2000 to 2003

Discussion in 'Information Technology' started by Alvaro Samagaio, Nov 16, 2005.

  1. Alvaro Samagaio

    Alvaro Samagaio
    Expand Collapse
    Guest

    Good afternoon to all is the following one has an application in Access 2000
    and converted it for 2003, only that now in certain formularios where I need
    to carry through querys when loading in a button to carry through querys it
    give me the following error "the Microsoft Office Access found a problem and
    has of being locked up. We lament any inconvenience that this can cause
    "after to give to this error it restart the application but the funny one is
    that it makes the calculos that I requested

    if they will be able to help me was thankful

    Alvaro
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Try working through the items in this sequence.

    1. Uncheck the boxes under:
    Tools | Options | General | Name AutoCorrect
    Explanation of why:
    http://allenbrowne.com/bug-03.html

    2. Compact the database to get rid of this junk:
    Tools | Database Utilities | Compact

    3. Close Access. Make a backup copy of the file. Decompile the database by
    entering something like this at the command prompt while Access is not
    running. It is all one line, and include the quotes:
    "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
    "c:\MyPath\MyDatabase.mdb"

    4. Open Access, and compact again.

    5. Open a code window.
    Choose References from the Tools menu.
    Uncheck any references you do not need.
    For a list of the ones you typically need in your version of Access, see:
    http://allenbrowne.com/ser-38.html

    6. Still in the code window, choose Compile from the Debug menu.
    Fix any errors, and repeat until it compiles okay.

    At this point, you should have a database where the name-autocorrect errors
    are gone, the indexes are repaired, inconsistencies between the text- and
    compiled-versions of the code are fixed, and reference ambiguities are
    resolved.

    If it is still a problem, the next step would be to get Access to rebuild
    the database for you. Follow the steps for the first symptom in this
    article:
    Recovering from Corruption
    at:
    http://allenbrowne.com/ser-47.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Alvaro Samagaio" <someone@mail.telepac.pt> wrote in message
    news:%23H$GeHd6FHA.632@TK2MSFTNGP10.phx.gbl...
    > Good afternoon to all is the following one has an application in Access
    > 2000 and converted it for 2003, only that now in certain formularios where
    > I need to carry through querys when loading in a button to carry through
    > querys it give me the following error "the Microsoft Office Access found a
    > problem and has of being locked up. We lament any inconvenience that this
    > can cause "after to give to this error it restart the application but the
    > funny one is that it makes the calculos that I requested
    >
    > if they will be able to help me was thankful
    >
    > Alvaro
    >
     

Share This Page