Access strange error!

C

Claire

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!
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top