ODBC failed

[jaryszek]

Hi,

i am getting error like this:
https://support.microsoft.com/pl-pl/...ked-to-a-sql-d

i want to show different msgbox for my user,



how can i do this?

Best,
Jacek

[Perceptus]

Do want to know how to trap errors in vba? When does this error occur?

[jaryszek]

I know how to trap errors.

I thought that there is possibility to change msgbox for my specific one.

So instead System ODBC failed changes this for example for "Ups, you can not do that".

I think that only way is refer to windows functions and procedures like here:

http://www.accessmvp.com/TomvanStiphout/OdbcErrors.htm

Best,
Jacek

[Perceptus]

IMO,Users should not run into ODBC error messages. I would recommend preventing the user from attempting to do what they can't. The suggested option of your link is possible, it explains everything you need to do.