<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=710161919-05032003><FONT face=Arial color=#0000ff
size=2>Tim</FONT></SPAN></DIV>
<DIV><SPAN class=710161919-05032003><FONT face=Arial color=#0000ff size=2>Just a
suggestion.</FONT></SPAN></DIV>
<DIV><SPAN class=710161919-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=710161919-05032003><FONT face=Arial color=#0000ff size=2>Dim
blnNeedsUpdate As Boolean</FONT></SPAN></DIV>
<DIV><SPAN class=710161919-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV>
<P><FONT face=Arial size=2><FONT size=2><FONT color=#0000ff><FONT
face=Arial>blnNeedsUpdate <SPAN class=710161919-05032003><FONT
color=#000000>=False</FONT></SPAN></FONT></FONT></FONT></FONT></P>
<P><FONT face=Arial size=2><FONT size=2><FONT color=#0000ff><FONT
face=Arial><SPAN
class=710161919-05032003></SPAN></FONT></FONT></FONT></FONT><FONT face=Arial
size=2>If validation1 = false
then</FONT> <BR> <FONT
face=Arial><FONT size=2><FONT color=#0000ff>blnNeedsUpdate <SPAN
class=710161919-05032003><FONT
color=#000000>=True</FONT></SPAN></FONT></FONT></FONT></P>
<P><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=710161919-05032003></SPAN></FONT>End if</FONT></FONT> </P>
<P><FONT face=Arial size=2>If validation2 = false
then </FONT><BR> <FONT
face=Arial><FONT size=2><FONT color=#0000ff>blnNeedsUpdate <SPAN
class=710161919-05032003><FONT
color=#000000>=True</FONT></SPAN></FONT></FONT></FONT></P>
<P><FONT face=Arial><FONT size=2><FONT color=#0000ff><SPAN
class=710161919-05032003></SPAN></FONT></FONT></FONT><FONT face=Arial size=2>End
if</FONT> <BR><FONT face=Arial size=2></FONT></P>
<P><FONT><FONT face=Arial><FONT size=2><SPAN
class=710161919-05032003>etc</SPAN></FONT></FONT></FONT></P>
<P><FONT><FONT><SPAN class=710161919-05032003></SPAN><FONT face=Arial><FONT
size=2><SPAN class=710161919-05032003>if <FONT size=2><FONT
color=#0000ff><FONT face=Arial>blnNeedsUpdate <SPAN
class=710161919-05032003><FONT color=#000000>=
true</FONT></SPAN></FONT></FONT></FONT></SPAN></FONT></FONT></FONT></FONT></P>
<P><FONT><FONT><FONT><SPAN class=710161919-05032003><FONT><FONT><SPAN
class=710161919-05032003></SPAN></FONT></FONT></SPAN><FONT face=Arial><FONT
size=2><SPAN
class=710161919-05032003>.edit</SPAN></FONT></FONT></FONT></FONT></FONT></P>
<P><FONT><FONT><FONT><FONT><SPAN class=710161919-05032003></SPAN><FONT
face=Arial><FONT size=2><SPAN class=710161919-05032003>change all
fields</SPAN></FONT></FONT></FONT></FONT></FONT></FONT></P>
<P><FONT><FONT><FONT><FONT><FONT face=Arial><FONT size=2><SPAN
class=710161919-05032003></SPAN>.update</FONT></FONT></FONT></FONT></FONT></FONT></P></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV><!-- Converted from text/plain format -->
<P><FONT size=2>Andy Lacey<BR><A
href="http://www.minstersystems.co.uk/">http://www.minstersystems.co.uk</A><BR><BR></FONT></P>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; 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>Swisher, Timothy B.<BR><B>Sent:</B> 05 March 2003
13:06<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Editing Records<BR><BR></FONT></DIV>
<P><FONT face=Arial size=2>Hello group, I have a procedure (A2k) that opens a
recordset (DAO) and cycles through the data validating/updating several fields
for each record. My question is, what is the best way to do this,
</FONT></P>
<P><FONT face=Arial size=2>Like this</FONT> </P>
<P><FONT face=Arial size=2>.edit</FONT> <BR><FONT face=Arial size=2>If
validation1 = false then</FONT> <BR>
<FONT face=Arial size=2>change data</FONT> <BR><FONT face=Arial size=2>End
if</FONT> </P>
<P><FONT face=Arial size=2>If validation2 = false then
</FONT><BR> <FONT face=Arial
size=2>change data</FONT> <BR><FONT face=Arial size=2>End if</FONT> <BR><FONT
face=Arial size=2>.update</FONT> </P>
<P><FONT face=Arial size=2>Or </FONT></P>
<P><FONT face=Arial size=2>If validation1 = false then</FONT>
<BR> <FONT face=Arial
size=2>.edit</FONT> <BR> <FONT
face=Arial size=2>change data</FONT>
<BR> <FONT face=Arial
size=2>.update</FONT> <BR><FONT face=Arial size=2>End if</FONT> </P>
<P><FONT face=Arial size=2>If validation2 = false then
</FONT><BR> <FONT face=Arial
size=2>.edit</FONT> <BR> <FONT
face=Arial size=2>change data</FONT>
<BR> <FONT face=Arial
size=2>.update</FONT> <BR><FONT face=Arial size=2>End if</FONT> </P>
<P><FONT face=Arial size=2>I have about 13 validations that need to be done on
about 90,000 records. Each validation goes to a SQL Server BE and check
the validity of the data. There is a huge difference in speed opening
and closing the recordset so many times, but if that is the better way to go,
then so be it. All help is appreciated. TIA.</FONT></P>
<P><FONT face=Arial size=2>Tim</FONT> </P></BLOCKQUOTE></BODY></HTML>