Why do I lose my reports once I close and reopen the database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can create, edit, and print my report. Then, when I close the database I
have no reports listed. All my other stuff, such as Queries and Tables are
there but no reports. Thanks
 
Sounds like the database has gone corrupt.

Firstly, verify you have some printer installed. Access can't handle reports
if there is no printer.

Then try this sequence (in order) to recover the database:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | 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
or in Access 2007:
Office Button | Manage | 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 (holding down the Shift key if you have any startup code),
and compact again.

5. Now create a new (blank) database:
File | New

6. Uncheck the Name AutoCorrect boxes in the new database.

7. Import everything from the old database:
File | External

8. Create a new report.
Close to test the new report survives.

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
 
Back
Top