<!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>...sorry Jim, you're right ...I used an
upgrade to get mine and didn't pay enough attention to the current full
price :(</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=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> Sunday, September 21, 2003 1:08
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>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>
<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>