Welcome to SPN

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

Sign Up Now!

Access strange error!

Discussion in 'Information Technology' started by Claire, Jul 28, 2006.

  1. Claire

    Claire
    Expand Collapse
    Guest

    When using Access 2000 just trying to run normal queries and reports an error
    is coming up with the error 'The report name '?' you entered in either the
    property sheet of macro is mispelled or refers to a report that doesn't
    exist.'

    Each time the '?' named report is different and is a very old report I
    havn't used for a long time.

    Am stuck as cannot find an error like it on this discussion site......any
    ideas welcome!
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Suggested 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/Repair

    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. If you have a macro named AutoKeys, temporarily rename it to (say)
    AutoKeysX.

    --
    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.

    "Claire" <Claire@discussions.microsoft.com> wrote in message
    news:7E67C654-656A-4F34-8D52-2DE82F5D158A@microsoft.com...
    > When using Access 2000 just trying to run normal queries and reports an
    > error
    > is coming up with the error 'The report name '?' you entered in either the
    > property sheet of macro is mispelled or refers to a report that doesn't
    > exist.'
    >
    > Each time the '?' named report is different and is a very old report I
    > havn't used for a long time.
    >
    > Am stuck as cannot find an error like it on this discussion site......any
    > ideas welcome!
     

Share This Page