Error trapping problem

Printable View

Jul 20th, 2004, 02:56 PM
ae_jester

Error trapping problem

Hi

I have made a 'database corruption utility' tool for our customers to use to determine which records in a specific table are corrupted (as happens often with access). My program creates a temporary table in a new database, and copies all data from the source table to the new one. I have included error trapping during the copy table routine, but that does not stop the program from showing the dreaded "___ has encountered a problem and needs to close. We are sorry for the inconvenience." error report dialog box.

It seems that when reading the corrupted record in the table being searched, the error is not trapped by visual basic and it just crashes.

Is there ANY way to trap these kinds of errors???
Jul 20th, 2004, 06:45 PM
Xmas79

Uuhmhm... Strange... With the On Error statement you should be able to catch ALL errors... BUT! If you are using some special 3rd part control, maybe you'll not be able to catch that errors... But if you're using "plain" vb you MUST catch.... Try posting the relative code....
Jul 20th, 2004, 09:10 PM
jhermiz

Re: Error trapping problem

Quote:

Originally posted by ae_jester
Hi

I have made a 'database corruption utility' tool for our customers to use to determine which records in a specific table are corrupted (as happens often with access). My program creates a temporary table in a new database, and copies all data from the source table to the new one. I have included error trapping during the copy table routine, but that does not stop the program from showing the dreaded "___ has encountered a problem and needs to close. We are sorry for the inconvenience." error report dialog box.

It seems that when reading the corrupted record in the table being searched, the error is not trapped by visual basic and it just crashes.

Is there ANY way to trap these kinds of errors???

Recordsets (if you are using them) have an Error object collection associated with them.