Forum Discussion
Error message 'Microsoft Access can't open the form 'Temp.''
It may actually be hidden in the Navigation Pane, by the way, which explains why you don't see it. However, the fact that Access closes means it's probably corrupted in any event.
I think the problem with your archived versions could be that this corruption was present for some time. That's happened to others before.
Another thing that error message suggests could also be the problem.
"It contains data that Microsoft Access doesn’t recognize."
Sometimes it does happen. When a database is created, we expect data to be in a certain format, with certain datatypes. Over time, that can change and newly encountered data no longer meets original expectations. You can eliminate that as a possibility by reviewing recent data.
Thanks George.
It can't simply be an issue of a corrupted file since everything was working fine until Saturday, and there's no way that (several) archived copies of the database sitting on my hard drive could also have corrupted themselves simultaneously in exactly the same way. But it does seem to be some kind of interface issue between the very old design of parts of the database, and MS Access (after the last set of updates...?)
Two odd things are: running any cross-tab query seems to generate the error message, but you can see on the screen behind the error message that the query has in fact had time to run correctly before the error message pops up. Secondly, once the error message is there, however you respond, Access just shuts itself down (with no more messages and no 'error report' generated). Sometimes if you relaunch it it opens in 'safe mode', sometimes it doesn't.
- That definitely sounds like corruption to me.
Either that or your newest data includes one or more values that are not within the range or datatype expected by the crosstab.
That sad, you can repair Access, or even reinstall it, to see whether that clears up the problem.