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