Access and Jet Errors

[KBDB]

When I try to get the error codes; I get an error: 3078: The Microsoft Office
Access database engine cannot find the imput table or query
'AccessAndJetErrors'. Make sure it exists and that its name is spelled
correctly.

Has the error file changed its name?

 

[Allen Browne]

In what version of Access do you find the table named AccessAndJetErrors?

You can get a particular error message (e.g. 2501) in the Immediate Window
with:
? AccessError(2501)

You can get a list of the JET errors in the JETERR40 file. Typical location:
"C:\Program Files\Common Files\microsoft
shared\OFFICE11\1033\JETERR40.CHM"

Or FMS has a list of the error numbers and descriptions:
http://www.fmsinc.com/MicrosoftAccess/Errors/ErrorNumber_Description.html

michka also has info on JET warnings that are not errors:
http://blogs.msdn.com/michkap/archive/2005/10/19/482694.aspx

 

[KBDB]

I worked in Access 97 & 2003; Both run the code for Errors with Access & Jet.
Now I using Access 2007. So, I searched for a new listing. It had the same
database. The error code displayed in my Run program. The new help version
had compile errors - I used the code listing from the help screen - coded
and ran with it - but the errors were with a self define type. So I went
back to the old version I had on hard copy; I posted that error. I can not
go back to the prior verisons of Access to run code and I lost my Error Code
Listing. I'm going to try your suggestions today (First, I sleep for 5
hours). Thanks for the reply. I'll check it out in about 5 hours... or
so....

Thanks!

Kathleen aka..KBDB