<!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>Editing Records</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=755400715-05032003><FONT face=Arial color=#0000ff size=2>Just
out of curiousity, can you use an Update query....making the validation part of
the criteria? That would probably be the fastest
method.</FONT></SPAN></DIV>
<DIV><SPAN class=755400715-05032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=755400715-05032003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Swisher, Timothy B.
[mailto:tswisher@gfnet.com]<BR><B>Sent:</B> Wednesday, March 05, 2003 7:06
AM<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>