I have an MS Access front end to an SQL Server back end. Everything is working fine except for the way a bad password is handled.
Where a bad password is part of the connection string I get an error message box and then a dialog box that would have me input the correct credentials for the SQL server. I would like to trap this so I can have my own custom error messge.
Dim db As DAO.Database
Dim tdf As DAO.TableDef
db.TableDefs.Append tdf '<---- error here with bad password