<!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 5.5.2653.12">
<TITLE>Editing Records</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">Like this</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">.edit</FONT>
<BR><FONT SIZE=2 FACE="Arial">If validation1 = false then</FONT>
<BR> <FONT SIZE=2 FACE="Arial">change data</FONT>
<BR><FONT SIZE=2 FACE="Arial">End if</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">If validation2 = false then </FONT>
<BR> <FONT SIZE=2 FACE="Arial">change data</FONT>
<BR><FONT SIZE=2 FACE="Arial">End if</FONT>
<BR><FONT SIZE=2 FACE="Arial">.update</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Or </FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">If validation1 = false then</FONT>
<BR> <FONT SIZE=2 FACE="Arial">.edit</FONT>
<BR> <FONT SIZE=2 FACE="Arial">change data</FONT>
<BR> <FONT SIZE=2 FACE="Arial">.update</FONT>
<BR><FONT SIZE=2 FACE="Arial">End if</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">If validation2 = false then </FONT>
<BR> <FONT SIZE=2 FACE="Arial">.edit</FONT>
<BR> <FONT SIZE=2 FACE="Arial">change data</FONT>
<BR> <FONT SIZE=2 FACE="Arial">.update</FONT>
<BR><FONT SIZE=2 FACE="Arial">End if</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">Tim</FONT>
</P>
</BODY>
</HTML>