Report stopped working

[Humphrey]

I have a report I've been working on for quite some time now and for some
reason it has stopped working this morning. I did edit one of the source
tables yesterday but this shouldn't have effected its operation.
In fact even attempting to copy the report or open the VBA behind it will
cause the database to crash. I tried creating a blank DB and importing
everything into it, but it crashes at the aforementioned report. If I simply
try to run the report it will flash open for less than a second before
shutting itself down. What's going on, and how do I fix it?

H

 

[Evi]

The big question is, what did you do to the source table?
Also, does the report contain any code or Parameter boxes?
If the report is based on a query, then does the query still work?

Look at the table. Do you see any signs of corruption (when one of my dbs
corrupted, I found strange changes to the Autonumber Primary Key field -
some of the autonumbers were actually missing and others were ridiculous
numbers. Look for bare rows in the table.

Evi

 

[Humphrey]

The underlying query still works in fact if I open the report in design mode
and preview the query it's all there. There's nothing wrong with the table;
the edit was simply changing the field size in one text field.
This report is the centre of the database and I thus need to be able to
recover it. Any ideas?

H

 

[Evi]

If you made the field size smaller, that may have knocked out some data
which might have caused problems. If you made it larger, then it shouldn't
have been an issue.

Another thing that I've found which caused strange problems, was field names
in my tables which were actually Access Functions or Properties. The word
Date, or less well known functions like Eval, Mod or These don't always
cause problems immediately but suddenly the problem will arise and it will
never be attributed directly to my field name. Could any of your field names
be like this?

Save the report's query and base a simple autoreport on that query.
Start setting the sorting/grouping to be the same as your previous report
one step at a time and test at each stage to see if you can duplicate the
problem.

What code is in your report?

This could be corruption, in which case you will be stuck with having to
re-create the report or pay an expert to do it but lets not assume that
until we've tried everything else
Evi