I'm using DoCmd.TransferDatabase to dynamically link to some SQL Server tables on the fly. If I'm not able to connect to the table I don't want the SQL Server to popup some dialog box. I would like to handle the error internally and not display the dialog box(es). Does any one know how to turn off these dialog boxes from SQL Server? Thanks.
If you open a connection using the OpenConnection method of a DAO.Workspace object, there are optional parameter (dbDriverNoPrompt, dbDriverComplete, dbDriverCompleteRequired) that seem to do just that. See Access Help on OpenConnection for more info.