Dale Kalsow
dkalsow at yahoo.com
Fri Aug 19 09:51:49 CDT 2011
Good Morning, I have attached a sql table in my access 2007 database. I can copy and paste records into just fine; how ever when I try to write to it using vba I receive the error "Run-time error '31456': ODBC--call failed." Here is my code: Dim rstRSs As DAO.Recordset Set rstRSs = currentdb.OpenRecordset("dbo_InternalPhoneRecord", dbOpenDynaset, dbSeeChanges) With rstRSs .AddNew ![IPRdatecalled] = datCallDateTime .Update End With I receive the error on the .Update statement. Does anyone have any idea? Thanks! Dale