err.number values 2

[OhioSteve]

I have an error handling question.

I have learned that the err.number property contains the error number, and err.description contains the description. For example, I know that if err.number=70 then err.description="Permission Denied". However, I CANNOT find a list of every error number and its description. Does anyone have that list?

PS: I know that one could add to the default list. My concern is with the standard vba values, not custom values.

 

[SgtJarrow]

Take a look at

http://msdn2.microsoft.com/en-us/library/aa200518(office.10).aspx

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[OhioSteve]

I created an mdb and attempted to execute AccessAndJetErrorsTable. Unfortunately, Access did not understand "ADOX". Perhaps I need to import something prior to running the function.

 

[PHV]

You must reference the Microsoft ADO Ext 2.? for DDL and Security library.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[OhioSteve]

You both get stars!

Someone may read this in the future. For their benefit, I will explain further. The procedure for adding the libraries (in Acc 2003) is:

1. Uncheck "Microsoft ActiveX Data Objects 2.5 Library.
2. Check "Microsoft ActiveX Data Objects 2.8 Library".
3. Check "Microsoft ADO extension 2.8 for DDL and Security".