Heenan, Lambert
Lambert.Heenan at AIG.com
Thu Jan 20 10:19:46 CST 2005
There are many solutions, but Rick Fisher's Find and Replace is my favorite. See http://www.rickworld.com/ Lambert > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [SMTP: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