Error detection and error handling in access 2007

[Shweta]

Hi All,

This is a question that was asked to me in an interview and I couldn't answer it.

The question is say, your manager asked you to prepare a report using access database. While preparing the report you get an error. Now, how to detect what the error is and how to handle it?

What should be the accurate answer for this question?

Please suggest.

Thanks in advance!

Regards,
Shweta

 

[jackd]

This is not the answer you interviewer would expect, but it is what you should do.

Get a copy of the free utility MZTools (vba version). MZ-Tools - Productivity Tools for Visual Studio .NET (C#, VB.NET), Visual Basic and VBA
With the click of a button you can error handling to any procedure. And this utility does much, much more.

And I recommend you add error handling to every procedure -- as a habit.

With 324 posts, I'm surprised you haven't done this already.

If you really are unsure of the concept then here is an article that may help
How do I... Add custom error handling to my Access forms and reports? | TechRepublic

And here is a must read to understand Error Handling MS Access
http://allenbrowne.com/ser-23a.html

 

[Shweta]

Thanks Jackd!

 

[Norie]

Shweta

Does this report involve any code?

If it does and that's where the error is you should start by using VBA's in-built debugging tools to locate the error, find out what caused it and then decide what to do.

One thing to remember - prevention is better than cure.

Also, if you are going to use stuff like On Error Resume Next then use it sparingly - it can actually hide errors