[AccessD] changing a field name througout the databse

..F&R is cheap and dirty and does what you need and is quick to update 
between Access versions ...but it processes every change serially and can be 
damn slow in a large database

..for a little bit more Black Moshannon's Speed Ferret is like going from a 
Chevy to a Ferrari ...it is dramatically faster and comes with a lot more 
options and db security ...but they are notoriously slow to update between 
versions.

..I've used both and much, much prefer Speed Ferret over F&R ...but 
..right now I'm using F&R on A2003 mdbs because Speed Ferret has not been 
updated for that version as yet ...but as soon as the update is available, 
I'll switch back.

..hth :)

William Hindman


----- Original Message ----- 
From: "Tesiny, Ed" <EdTesiny at oasas.state.ny.us>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Thursday, January 20, 2005 11:04 AM
Subject: RE: [AccessD] changing a field name througout the databse


>I would suggest using Rick Fisher's Find and Replace, free for 30 days
> then $37 for a registered copy.  It has saved me tons of time.  You can
> find it at www.rickworld.com There is also SpeedFerret but I haven't had
> any experience with it.
>
> Ed Tesiny
> EdTesiny at oasas.state.ny.us
>
>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of withington
>> Sent: Thursday, January 20, 2005 10:56 AM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] changing a field name througout the databse
>>
>> I have a client who created a database in Access. When they named the
>> fields, they left spaces in some of the field names. Everything was
>> working fine until the database was asked to work with Mapquest.
>> Apparently Mapquest does not like the spaces.
>>
>> Is there a way to universally change the field name every
>> time it occurs
>> to not have any spaces?  They are using Access 2000
>>
>> thank you
>> augusta
>>
>> >
>> >
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>