Problem with Access 2002 SP3

[Allen Browne]

Error 3021 is a known issue with A2002 SP3 after a delete. The workaround is
to use error handling to trap and ignore that error in the context it arises
(e.g. Form_AfterDelConfirm.)

I'm not aware of error 3079 being patch-specific with A2002. If you have
Name AutoCorrect on, you might want to ensure it is turned off:
http://allenbrowne.com/bug-03.html

 

[JM7]

I have one computer with Access 2002 SP3 - the others don't have any service
packs.

An MDB app that I am running on SP3 always has errors like 3021 3079
regarding USER access errors when a delete command is issued - this doesn;t
happen with the other computers without the SPacks - is there a known error
with the SP that could cause this?

The sad truth is my ACCESS 97 running on WIN 98 is still the most stable and
troublefree version.

 

[Allen Browne]

To be honest, I can't recall what issues SP3 addressed in Office 2002. Off
the top of my head, the changes were minor w.r.t. Access. I'm sure you could
the info in the knowledgebase at support.microsoft.com.

Regarding error handling, I imagine error 3021 crops up in a limited number
of places only, e.g. a custom button that deletes a record. You would
include error handling in this procedure. In the error handler part, you put
something like this:
If Err.Number <> 3021 Then
MsgBox "Error " & Err.Number & ": " & Err.Description
End If
Resume xxx

So, if error 3021 occurs, it just resumes without the msgbox.

If you need suggestions on how to set up an error handler, see:
Error Handling in VBA
at:
http://allenbrowne.com/ser-23a.html
It does more than what you need (i.e. it logs the errors to a table), but
illustrates the principle too.

 

[JM7]

Thanks Allen,

Are there any benefits in having SP3 in Access 2002?

It looks like it would be easier to remove SP3 than going back to re-doing
all that code. Besides I don't think I know how to do the following:

""> to use error handling to trap and ignore that error in the context it
arises ""


Thanks

John
Sydney

 

[JM7]

Thanks Allen,

You've been a big help with this one - can't wait to get back to the office
to implement your suggested code.

John