Forum Discussion
Error message 'Microsoft Access can't open the form 'Temp.''
I work with an Access database designed 30 years ago with which I've had no problems with until today. Suddently, when I try to run some functions (crosstab query or design a query) I'm getting this ...
This sounds like the Access file (probably an mdb if it's 30 years old) has been corrupted. The error message is telling you how to recover from this problem. However, the name of the form in question, "Temp", suggests it is intended to be a temporary object. And that means inspecting the VBA in this mdb to see if you can figure out where and how it is instantiated.
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.
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.