<!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.2715.400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=335401515-05032003><FONT face=Arial size=2>I think I need to
use a recordset because I do not have the validation data available to the app
in any other form.</FONT></SPAN></DIV>
<DIV><SPAN class=335401515-05032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=335401515-05032003><FONT face=Arial size=2>More
background...</FONT></SPAN></DIV>
<DIV><SPAN class=335401515-05032003><FONT face=Arial size=2>We get a file from
one of our apps, I import that data into an Access db, that data needs to be
validated against our SQL Server. The data from the SQL Server is unbound,
no table links. I basically send the server a project number, if it
returns a record, its valid, if not its an error. We are checking for
errors on project numbers, whether its active etc. We also use the project
number and other data to find information about the project and add that to
the record, who it belongs, client, etc. There is different criteria for
each validation. For each record, I could have anywhere from no
changes to 13 changes. </FONT></SPAN></DIV>
<DIV><SPAN class=335401515-05032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=335401515-05032003><FONT face=Arial size=2>Thanks
again.</FONT></SPAN></DIV>
<DIV><SPAN class=335401515-05032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=335401515-05032003><FONT face=Arial
size=2>Tim</FONT></SPAN></DIV>
<DIV><SPAN class=335401515-05032003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Susan
Harkins [mailto:harkins@iglou.com] <BR><B>Sent:</B> Wednesday, March 05, 2003
10:03 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] Editing Records<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>I didn't thoroughly check, but is there a reason
you need to use a recordset to do this -- it looks to me like an Update query
might be faster. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=tswisher@gfnet.com href="mailto:tswisher@gfnet.com">Swisher,
Timothy B.</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, March 05, 2003 8:06
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Editing
Records</DIV>
<DIV><BR></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></BLOCKQUOTE></BODY></HTML>