Access AfterInsert with SQL Server returns #DELETED

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003 with SQL Server v.8 backend displays #DELETED after inserting a
record. We've found we can requery the form to alleviate this error. Is
this the correct thing to do? Also, once we've added the record and
requeried the form, we are sitting on the last record in the recordset
instead of the record we just added. Is using the bookmark property the only
way to reposition our pointer in the recordset? Which event is used to
perform this functionality? Can it be done in the AfterUpdate() event?
 
I had this problem many time before and it was because i had the Primary Key
on the table a field that the user can update. When I changed the pk to an
autonumber (or something) this problem went away. I don't know if this
helps but an idea.

Steph
 
Thank you for your reponses. The answer to my question is as follows: When
using SQL Server as your back-end, be sure your primary key fields are set to
INT. Takes care of the #DELETED issue.
 
Back
Top