[AccessD] changing a field name througout the databse

withington awithing at twcny.rr.com
Fri Jan 21 08:33:08 CST 2005


thanks for your thoughts, I think that I will try F&R first and go from 
there. This database is not so huge . . .



William Hindman wrote:

> ..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
>>



More information about the AccessD mailing list