[AccessD] SQL table update error

Dale Kalsow dkalsow at yahoo.com
Fri Aug 19 10:28:26 CDT 2011


MS SQL Server 2008

 
IPRDatecalled is a data type of datetime.
 
From: Stuart McLachlan <stuart at lexacorp.com.pg>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Friday, August 19, 2011 10:17 AM
Subject: Re: [AccessD] SQL table update error

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
> 




-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list