Can anyone tell me what I should be looking for when I get an error message "[Microsoft][ODBC Microsoft Access Driver] Internal OLE Automation Error"
This appears only in my executable not in the design environment and appears to happen with this code
Set tmpRecordset = New ADODB.Recordset
TmpSQL = "SELECT USER_LOGIN_NAME, USER_LOCKED FROM Users"
TmpSQL = TmpSQL & " WHERE USER_LOCKED = TRUE"
tmpRecordset.Open TmpSQL, sConnection, adOpenKeyset,adLockOptimistic