<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1226" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>William,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Where did you find SF for $169, their web site
quotes $199? But with all things considered I think that I'd be better off with
a subscription, because when they release an Access 11 version, it would cost
another $100 to get the latest version.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm going to downloaf both SF and F & R and try
them out. I do like the advantage that SF has with the ability to do SQL 2000 in
addition to multiple flavors of Access. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Anyway, many thanks to those who
responded.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Jim</FONT></DIV>
<BLOCKQUOTE
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=wdhindman@bellsouth.net href="mailto:wdhindman@bellsouth.net">William
Hindman</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, September 20, 2003 7:23
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Global table
changes</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>...ach!!! its <A
href="http://www.moshannon.com">www.moshannon.com</A> :(((((</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>So, then, to every man his chance -- to every man,
regardless of his birth, his shining golden opportunity -- to every man his
right to live, to work, to be himself, to become whatever his manhood and his
vision can combine to make him -- this, seeker, is the promise of America.
<BR>-- Thomas Wolfe </DIV>
<DIV> </DIV>
<DIV><BR> </DIV>
<BLOCKQUOTE
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=wdhindman@bellsouth.net
href="mailto:wdhindman@bellsouth.net">William Hindman</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, September 20, 2003 8:17
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Global table
changes</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>...and I firmly disagree :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...I use SF (Speed Ferret) from <A
href="http://www.mosnannon.com">www.mosnannon.com</A> and it plain beats the
daylights out of F&R ...I just finished doing a use comparison
between SF and FR (Find&Replace) because so many here had
recommended it and I needed to either upgrade my version of speedferret or
replace it with FR.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>...the ONLY advantage F&R has is cost ...at
$49 it's far cheaper than SF at $169 :(</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>...but FR is a serial F&R tool and its
dead slow compared to SF ...I mean DEAD slow ...one use of FR and I had no
question about spending the extra money to upgrade my current SF
version :(</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...and dear god not only is FR slow but
once you've started a F&R there is no getting out short of crashing
Access ...loved that! :(</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>...another major difference is the
way SF lets you view all of the pending changes on one screen
and select which to implement ...and remembers what was changed so that you
can roll it back if you make a mistake ...FR has no comparable capability
that I could find ...and I looked</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>...SF is multi platform ...one tool to run A97
thru AXP AND you get VB6 AND SQL Server capability as well ...FR is
Access only and you have to load a different version for each version of
Access :(</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>...now I know that I'm going to get a ton of FR
fan mail from this list ...which is what led me to try FR in
the first place ...so before you go penning your little love notes folks, do
what I did and dl demos of both tools ...if after doing a side-by-side
comparison you're still an FR fan, why god bless your
pea-pickin' little soul cause you need it! :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...the only fault I've ever had with SF is that
they tend to be behind the power curve in getting new releases out ...it
was more than six months after I had XP on my systems before they
released a production SF version that worked with it :(</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>...but my bottom line is this ...the extra $120
SF costs is well worth the money ...that's less than two billable hours and
I easily saved more than that using it rather than FR just once to make
major db changes :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>So, then, to every man his chance -- to every man,
regardless of his birth, his shining golden opportunity -- to every man his
right to live, to work, to be himself, to become whatever his manhood and
his vision can combine to make him -- this, seeker, is the promise of
America. <BR>-- Thomas Wolfe </DIV>
<DIV> </DIV>
<DIV><BR> </DIV>
<BLOCKQUOTE
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=davesharpe2@cox.net href="mailto:davesharpe2@cox.net">dave
sharpe</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion
and problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, September 20, 2003
1:21 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Global table
changes</DIV>
<DIV><BR></DIV>
<DIV><FONT face="Courier New" size=2>Jim</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>I agree wholeheartedly with
Rocky.</FONT></DIV>
<DIV><FONT face="Courier New" size=2>I've used since Acc95 and don't know
how I'd get alone without it.</FONT></DIV>
<DIV><FONT face="Courier New" size=2>You can get it from Rich's site
</FONT><FONT face="Courier New" size=2><A
href="http://www.rickworld.com/">http://www.rickworld.com/</A></FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Dave</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<BLOCKQUOTE
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=bchacc@san.rr.com href="mailto:bchacc@san.rr.com">Rocky Smolin
- Beach Access Software</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion
and problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, September 20, 2003
12:54 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Global table
changes</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Jim:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I use Rick Fisher's Find and Replace.
Free trial period but it will sell you. I use it a lot. It's
very elegant, very complete. Give it a try.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
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=jmoss111@bellsouth.net
href="mailto:jmoss111@bellsouth.net">jmoss111</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers
discussion and problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, September 20,
2003 7:27 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Global table
changes</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Is there a way to globally modify the
name of field objects in all of the tables contained in a
database? I import anywhere from 1 to 1000 Excel spreadsheets,
dbf files, mdb's or text files that contain similar data where
the fields are named similarly but not uniformly. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Jim</FONT></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD
mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>