[AccessD] SQL table update error

Just a WAG, but did you dim something as DAO.Database and then set
currentdb?


On Fri, Aug 19, 2011 at 10:51 AM, Dale Kalsow <dkalsow at yahoo.com> 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
>