Err numbers - new programmer question

[Guest]

Is there a good reference listing Access error descriptions given the error
number?

Or... is there a good way to use the immediate window to read error
descriptions when I input an error number? (I'm trying to follow examples of
code to learn programming, but I can't always understand the error just by
knowing its number)

Thank you

 

[Douglas J. Steele]

Use the AccessError function:

?AccessError(3210)
The connection string is too long.

 

[Dirk Goldgar]

In

Is there a good reference listing Access error descriptions given the
error number?

Or... is there a good way to use the immediate window to read error
descriptions when I input an error number? (I'm trying to follow
examples of code to learn programming, but I can't always understand
the error just by knowing its number)

Thank you

In the Immediate window, you can invove the AccessError function and see
what it returns:

?AccessError(3265)
Item not found in this collection.

There was a function in the Access 97 help file that would create a
table of Access and Jet errors. I don't have a copy of the source code
handy, but if you google for "AccessAndJetErrors" you should be able to
find it reposted.