Access / System crashed while generating report

[Dennis]

Hi,

I'm on XP PRO w SP3 running Access 2003 via Office XP Pro.

I was creating a report using the report wizard and Access and XP Pro hung
up. I waited 5 minutes and the system was still hung up. I then manually
powered down the computer.

When I get back into my Access project, I immediately receive the error
message "The report name 'Report1' you entered in either the property sheet
or macro is misspelled or refers to a report that does not exist. If the
invalide report name is a macro, an Action Failed dialog box will display the
macro's arguments afer you click ok. Open the Macro window, and enter the
correct report name."

It is not a Macro as I don't write them. I searched the Internet for the
message and the few responses tell me to create a new database and import
from the old database. When I do that, I immediately receive the above error
message on the new database.

Any suggestions on how to clear this error?

Thanks,

 

[Jeanette Cunningham]

It sounds like there is some corruption in that report you were creating
when access shut down.

To do the trick with importing all in to a new database, import everything
except all reports into the new database.
Then import only the reports that you know will work OK, leaving the
corrupted one or ones in the old database.
That should get rid of the corruption.

See this link on recovering from corruption
http://www.allenbrowne.com//recover.html

http://www.allenbrowne.com//ser-47.html



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Dennis]

Jeanette,

I've already tried that. I can import the tables and queries, but when I
try to import the forms, reports, and modules I receive the error:

"Name conflicts with existing module, project, or object library."

I've even created a new blank db and tried to import just one form and I
receive the same error.

I tried importing forms my previous version of this database and I was able
to import the forms. However, I would all of the changes I've made in the
last three weeks. Not a good option.

Any other suggestions?

 

[Dennis]

Jeanette,

I was able to do what you suggested, I just had do it differently.

I created a blank database with a new name. Since I could not import from
the original to the new, I tried exporting from the old to the new. And that
worked!

I have everything exported and imported and it appears to be working. This
is only the 4th time my forms have been corrupted. Fortunately I have
relatively few object. How do people with a lot of object prevent
corruption?

Or is it just a case of backup, backup, backup, backup?

If is is a case of backup, can I automate it from within Access so that each
time I start or end, it will ask me if I want to backup my db?

Thanks

 

[Jeanette Cunningham]

There are some tips on avoiding corruption here
http://www.allenbrowne.com//ser-25.html

You need good backups. If the work you have just completed took a lot of
time and effort and you don't want to lose it, then back it up. There is no
need to wait till you close the database.

In A2007 you can go Alt + F + M + K to backup.
Create a folder called backups.
Save the first backup to the folder.
After that access will remember where to save your backups.
Access will also date and number your backups - it makes it very easy to
backup.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Dennis]

Jeanette,

Thanks, I will do that more often.

 

[Tony Toews [MVP]]

I've already tried that. I can import the tables and queries, but when I
try to import the forms, reports, and modules I receive the error:

"Name conflicts with existing module, project, or object library."

This almost sounds like the name of a module conflicts with the name
of a form or report. Or something like that.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/