<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=142293621-07032003><FONT face=Arial color=#0000ff size=2>No,
those are just data fields.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
accessd-admin@databaseadvisors.com [mailto:accessd-admin@databaseadvisors.com]
<B>On Behalf Of </B>Wortz, Charles<BR><B>Sent:</B> Friday, March 07, 2003
11:21 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Cc:</B> Roni
Ronyak<BR><B>Subject:</B> RE: [AccessD] Intermittent #Deleted
Records<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial color=#0000ff size=2>Dan,</FONT> </P>
<P><FONT face=Arial color=#0000ff size=2>Is the information in the combobox
that is getting changed either a PK or a FK? Better not be.</FONT> </P>
<P><B><FONT face=Arial color=#0000ff>Charles Wortz</FONT></B> <BR><FONT
face=Arial color=#0000ff>Software Development Division</FONT> <BR><FONT
face=Arial color=#0000ff>Texas Education Agency</FONT> <BR><FONT face=Arial
color=#0000ff>1701 N. Congress Ave</FONT> <BR><FONT face=Arial
color=#0000ff>Austin, TX 78701-1494</FONT> <BR><FONT face=Arial
color=#0000ff>512-463-9493</FONT> <BR><FONT face=Arial
color=#0000ff>CWortz@tea.state.tx.us</FONT> </P><BR>
<P><FONT face=Arial></FONT> <FONT face=Tahoma size=1>-----Original
Message-----</FONT> <BR><B><FONT face=Tahoma size=1>From: </FONT></B>
<FONT face=Tahoma size=1>accessd-admin@databaseadvisors.com [</FONT><A
href="mailto:accessd-admin@databaseadvisors.com"><U><FONT face=Tahoma
color=#0000ff
size=1>mailto:accessd-admin@databaseadvisors.com</FONT></U></A><FONT
face=Tahoma size=1>] </FONT><B> <FONT face=Tahoma size=1>On Behalf
Of</FONT></B> <FONT face=Tahoma size=1>Dan Waters</FONT> <BR><B><FONT
face=Tahoma size=1>Sent: </FONT></B> <FONT face=Tahoma
size=1>Friday 2003 Mar 07 11:09</FONT> <BR><B><FONT face=Tahoma
size=1>To: </FONT></B> <FONT face=Tahoma
size=1>accessd@databaseadvisors.com</FONT> <BR><B><FONT face=Tahoma
size=1>Cc: </FONT></B> <FONT face=Tahoma size=1>'Roni
Ronyak'</FONT> <BR><B><FONT face=Tahoma
size=1>Subject: </FONT></B> <FONT
face=Tahoma size=1>[AccessD] Intermittent #Deleted Records</FONT> </P>
<P><FONT face=Arial size=2>Folks,</FONT> </P>
<P><FONT face=Arial size=2>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 face=Arial size=2>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 face=Arial size=2>Any suggestions on what the next steps could be
would be greatly appreciated!</FONT> </P>
<P><FONT face=Arial size=2>Thanks,</FONT> <BR><FONT face=Arial size=2>Dan
Waters</FONT> <BR><FONT face=Arial size=2>Quality Process Solutions</FONT>
</P></BLOCKQUOTE></BODY></HTML>