<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6389.0">
<TITLE>RE: [AccessD] Intermittent #Deleted Records</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Dan,</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Is the information in the combobox that is getting changed either a PK or a FK? Better not be.</FONT>
</P>
<P><B><FONT COLOR="#0000FF" FACE="Arial">Charles Wortz</FONT></B>
<BR><FONT COLOR="#0000FF" FACE="Arial">Software Development Division</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">Texas Education Agency</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">1701 N. Congress Ave</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">Austin, TX 78701-1494</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">512-463-9493</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial">CWortz@tea.state.tx.us</FONT>
</P>
<BR>
<P><FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd-admin@databaseadvisors.com [</FONT><A HREF="mailto:accessd-admin@databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">mailto:accessd-admin@databaseadvisors.com</FONT></U></A><FONT SIZE=1 FACE="Tahoma">] </FONT><B> <FONT SIZE=1 FACE="Tahoma">On Behalf Of</FONT></B> <FONT SIZE=1 FACE="Tahoma">Dan Waters</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Friday 2003 Mar 07 11:09</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 FACE="Tahoma">accessd@databaseadvisors.com</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Cc: </FONT></B> <FONT SIZE=1 FACE="Tahoma">'Roni Ronyak'</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Subject: </FONT></B> <FONT SIZE=1 FACE="Tahoma">[AccessD] Intermittent #Deleted Records</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Folks,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">A database I have worked on has an intermittent problem. This is a main form and a subform in Access XP. The database is split FE/BE. The subform is continuous and has a table as its recordsource that is on the many side of a 1-many relationship with the table that is the record source for the main form. The database is set to individual record locking and is also set to edited record. The table for the subform is also on the 1 side of a 1-many relationship for four other tables. Every table has a primary key based on an autonumber, and that primary key is the only index on each table.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">The problem is that, sometimes, when someone changes existing information in one of the comboboxes on the subform, the entire record in the subform immediately has all of it's information in every field changed to #Deleted. A search of the MSKB under #Deleted found information that suggested this happens when an Access FE is using a SQL BE, but no discussion of an Access FE using an Access BE. We have been able to trap an error which indicates that we are trying to do an rst.update without first doing an rst.edit, but since the forms are bound to the tables this doesn't make sense. Also, the code behind the subform comboboxes doesn't lead to any other code which edits and updates a recordset.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Any suggestions on what the next steps could be would be greatly appreciated!</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks,</FONT>
<BR><FONT SIZE=2 FACE="Arial">Dan Waters</FONT>
<BR><FONT SIZE=2 FACE="Arial">Quality Process Solutions</FONT>
</P>
</BODY>
</HTML>