Can’t Open Reports in a Microsoft Access Database

Question

I have a problem. I want to open a report in my microsoft access file in design form, but MS Access doesnt open this report. I dont get any error message, and without freezing.

I have no problem with other report files, but for a special report I have this problem. How can I solve this problem?

Sorry, your question is very unclear. Could you please try editing it again? You say design form, then report. What is is? — PaulFrancis, Jan 14 '15 at 09:46
So add the error with its appropriate error number and description. — PaulFrancis, Jan 14 '15 at 09:58
I am getting no error. I cant open the report without any error message or freezing — Kaja, Jan 14 '15 at 10:01
Can you export the report do a different MDB file? what happens? (probably nothing!) — Nick.Mc, Jan 14 '15 at 10:51

score 0 · Accepted Answer · edited May 23 '17 at 11:50

As much as you probably don't want to hear this, I have encountered this a number of times and the best solution was to create a new database and copy each item into it one-by-one. Sometimes a database carries enough corruption so that even a compact/repair doesn't remove it.

As a "first line of defense" you can try using the undocumented Decompile switch, but it's my experience that it rarely works. Still, it's worth a shot since it's quick and simple.

Can’t Open Reports in a Microsoft Access Database

1 Answers1