Our main app is an Access front end with a SQL back end. The connection between Access and SQL is ODBC. This can occasionally be prickly. Many...

I'll answer my own post, in part. The flat file that contains the redirected failed rows has a couple of error columns. One of the columns is the error code...

Well, one way to do this is to go under Tools, Startup in Access.  You can specify a form to popup.  Then put this code in your form and trigger it...

Sharon,

Here is the code we use:

Public Sub RefreshDSN(strDSNName As String, strDatabaseName As String, Optional frmStatus As Form)

Dim tdftemp As TableDef

Dim strConnect As String

On Error GoTo ErrLog

Open "c:\RefreshLog.txt" For Output As...

Are you using System DSN or User DSN?  We use System DSN and rarely have this problem.  Additionally when our Access app starts up we pop up a splash screen...