Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
MS Access Reports Disappearing?
I have two databases in which I have created reports. After creating each report I save it and verify that it is in the list of reports. However, when I close the database and open it again, the reports have vanished. Yet still, if I try to create a new report with the same name, it says I can't because there is a naming conflict.
I do have other databases that do not have this problem.
The common link between the two problem databases is the actually data itself in the tables.
View hidden objects was already checked.
I had done a compact and repair before, but did it again just to see if a second try would help--it didn't. Thinks just got worse. I had imported a report from another database and then renamed it. Not it has restored it to its old name and won't let me access it.
I've tried importing from another DB with no success.
2 Answers
- Capt CrasherLv 61 decade agoFavorite Answer
Sounds like a REALLY bad glitch in the underlying code of that particular DB.
Try creating a new DB, and then "IMPORT ALL" from the old DB (click Import, then just click each tab and "select all").
That kind of "rebuild" has saved me DAYS of rewriting before...
lastly, I would say check through the Microsoft Knowledge base, and then go hit one of the developer forums. I pasted my favorite below, but there are others...
Source(s): 9 years developing MS Access Microsoft Knowledge base: http://support.microsoft.com/ http://www.utteraccess.com/ - Anonymous1 decade ago
The only thing I can think of is that the original report you are duplicating is "hidden". Thus, anytime you create a new file with the same name, it says it already exists (because it does, you just can't see it).
To verify, go to Tools-->Options-->View
Show-->Hidden Objects should be enabled (checked).
If you can now see the old report (slightly greyed out), then you need to change its View Properties.
Highlight the report in question. (single-click)
From Toolbar menu select: View-->Properties
Clear the "hidden" attribute. (unchecked)
If that's not it, try:
Tools-->DatabaseUtilities-->Compact and Repair
If that's not it..... good luck.
