Hello,

I need to change all field names across my MDB using the
following rules:

1. Spaces within field names are replaced by underscores
2. Field names are to be in all caps (upper case)

Is there a utility or programmatic way to do this
throughout the MDB?

I don't want to have to do this manually!

Thanks,

Rajat

i think you can write a DAO code with loops through all tabledefs, and then
through all fields of each tabledef
or look at this find&replace utility:
www.rickworld.com

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Razor" <(E-Mail Removed)> wrote in message
news:2419801c45f03$973637f0$(E-Mail Removed)...
> Hello,
>
> I need to change all field names across my MDB using the
> following rules:
>
> 1. Spaces within field names are replaced by underscores
> 2. Field names are to be in all caps (upper case)
>
> Is there a utility or programmatic way to do this
> throughout the MDB?
>
> I don't want to have to do this manually!
>
> Thanks,
>
> Rajat