<div>
I did a compact and repair on the database and it is currently working.
</div>


I did a compact and repair on the database and it is currently working.

<div>
<div class="content wysiwyg-content">
I'm getting a odbc failed error (80004005) when updating a recordset with addnew and update. &nbsp;I'm using Access as a front end to a SQL server database. &nbsp;The error does not always occur. &nbsp;What do I need to look for?
</div>
</div>


I'm getting a odbc failed error (80004005) when updating a recordset with addnew and update.  I'm using Access as a front end to a SQL server database.  The error does not always occur.  What do I need to look for?

odbc failed error (80004005) when using addnew/update on a recordset in Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.