|  | Cancel Error |  | |
| | | Bewildered |  |
| Posted: Wed Sep 03, 2008 2:59 pm Post subject: Cancel Error |  |
After generating a report, if I click on 'cancel' I get an error msg from Microsoft that they have experienced an error and have to shut the database down. I just switched to Access 2007 and did not have this issue with Access 2000.
Any assistance would be greatly appreciated. |
| |
| | | Jerry Whittle |  |
| Posted: Wed Sep 03, 2008 3:45 pm Post subject: RE: Cancel Error |  |
| |  | |
At times like this, nothing beats a good backup. In fact make a complete backup of your database now and put it away for safe keeping.
That kind of error is often database corruption OR a problem with Access itself. Is this "cancel" button the X on the report or something created on a form or menu? Is it the Close Print Preview button? If something created by you, check the code behind that button.
Do you have the latest service pack installed. Office 2007 is up to SP1. Go to the Office Button then select the Access Options button towards the lower right of the pop-up. Next go down to Resources and see if it says SP1 in the small print under the "about Microsoft Office Access 2007 line.
If it's corruption, below are some resources.
Tony Toews has an excellent web page on database corruption. LINK
Allen Brown also has excellent info on corruption. LINK
I have a white paper in a Word document named Fix Corrupt Access Database towards the bottom this page: LINK -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Bewildered" wrote:
| Quote: | After generating a report, if I click on 'cancel' I get an error msg from Microsoft that they have experienced an error and have to shut the database down. I just switched to Access 2007 and did not have this issue with Access 2000.
Any assistance would be greatly appreciated.
|
|
| |
|
|