Stuart McLachlan
stuart at lexacorp.com.pg
Fri Aug 19 10:17:04 CDT 2011
What version of SQL Server?
What is the datatype of IPRdatecalled?
--
Stuart
On 19 Aug 2011 at 7:51, Dale Kalsow wrote:
> 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 --
> AccessD mailing list AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd Website:
> http://www.databaseadvisors.com
>