Err numbers - new programmer question

B

Becky

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
 
D

Douglas J. Steele

Use the AccessError function:

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

Dirk Goldgar

In
Becky said:
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
Click to expand...

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.
 
Top