Michael
2008-09-28 01:58:00 UTC
After upsizing a working Access 2003 MDB database in Access 2007 using SSMA,
records inserted through a subform contain #deleted in the fields after the
update has completed. The source for the subform is an ODBC linked join
query implemented in an SQL Server 2005 view. I don't think there is a
fundamental problem with the view because the insert actually does insert the
data into the database. Fields in only one table of the join are being
updated.
A requery in the form AfterUpdate event gets rid of the #deleted values but
the recordset is repositioned to the first record in the set.
Is there a way to fix this? If I must use the requery, I don't want the
position of the recordset to change. Using a bookmark won't work with the
requery.
BTW the VBA code uses DAO 3.6.
records inserted through a subform contain #deleted in the fields after the
update has completed. The source for the subform is an ODBC linked join
query implemented in an SQL Server 2005 view. I don't think there is a
fundamental problem with the view because the insert actually does insert the
data into the database. Fields in only one table of the join are being
updated.
A requery in the form AfterUpdate event gets rid of the #deleted values but
the recordset is repositioned to the first record in the set.
Is there a way to fix this? If I must use the requery, I don't want the
position of the recordset to change. Using a bookmark won't work with the
requery.
BTW the VBA code uses DAO 3.6.