Full Version: Error - The Data Was Added To The Database But The Data...
UtterAccess Forums > And More... > Microsoft SQL Server
hk1
I'm testing using Disconnected ADO Recordsets in a datasheet view form. When I edit a record I get the following error message:
quot;The data was added to the database but the data won't be displayed in the
form because it doesn't satisfy the criteria in the underlying record source."
I'm not using any triggers or stored procedures. I'm using SQL Server 2008 Express and Access 2007 (all updates installed) on Windows XP SP3.
Ofound this article and installed the hotfix. I've rebooted my computer but the problem continues.
http://support.microsoft.com/kb/961451
Just wondering if anyone has any ideas how I can possibly work around this problem.
hk1
I've found a satisfactory work-around for this problem.
You have to set the form's ResyncCommand to be the same as the query for the ADO Recordset (or in other words, the form's RecordSource) except that the ResyncCommand needs to end with a WHERE clause as show below. The ResyncCommand must include the same fields, tables, and joins.
Here's an example of my ResyncCommand:
CODE
Me.ResyncCommand = "SELECT i.*, c.lft FROM tblInventory AS i LEFT JOIN tblCat AS c ON i.catid = c.catid WHERE i.ID = ?"

This problem and it's solution was mentioned in an article posted at ASPAlliance:
http://aspalliance.com/articleViewer.aspx?aId=989&pId=-1
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.