What are reasons why I cannot create NEW Report?

[Guest]

Prior to creating a REPORT in Design or Wizard, I receive an message: You do
not have exclusive use of the database at this time etc. When I click on OK,
the Wizard is enabled and I can go thru all the motions. When I clik on
FINISH, I receive an window that states that WIZARD could not create the
REPORT. I do have table or query in place.

Wizard goes thru all the motions but at FINISH, get window: The wizard is
unable to create your report.

DESIGN: After the "You do not have exclusive etc" message, Design will not
respond at all.

 

[Allen Browne]

1. Close the database. Look in the folder where the database resides for an
ldb file with the same name as your mdb. If found, delete the small ldb.
Access uses it to record locking information, and normally deletes this file
when the program closes. However, if there is a crash, the file does not get
deleted, and may contain spurious locking info. that blocks things. (If it
won't delete, restart the computer and try again.)

2. Make a back up copy of the mdb.

3. Open the database, holding down the Shift key so any startup code does
not run.

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

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

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

7. Open Access, and compact again.

8. If this is Access 2002 or 2003, press Ctrl+G to open the Immediate
Window, and enter:
? Printer.DeviceName
If this does not return the name of your default printer, post back. (Access
uses the printer metrics to lay out the report, so if the printer is not
available, reports won't work correctly.) Note that you cannot check the
printer this way in Access 2000 or earlier.