Changing field Name in Table Design

[NOVAmichelle]

Hi. I'm building out my database and in the process have realized that some current field names need to be renamed. If I rename a field in the table design, will it automatically update my forms, queries, reports etc with the new field name?
Thanks

 

[ddean1968]

No it will not, the any other object linking to that field will not be able to find it and generate errors. Unless someone knows a way to have access relink these.

However until someone post this, I would not reccomend it unless you wish to manually recreate the links.

 

[NOVAmichelle]

This is another reason why I lean to this site for answers when I am unsure. Another analyst in my group told me they WOULD change but I wasn't sure. Maybe someone else will reply. Thanks, I'll take your advice and sit on it.

 

[MD5150]

When you change the field names, you should always take a look at everything linked to that field; queries, form control sources, and code. Sometimes Access actually does references for you, but never in code. And you should always double-check everything anyways.

If you're worried the change might take you down in production, then just try it out on a copy of the database that's not ran in production and see how much fixing there is to do.

Mike Dorthick

 

[RoyVidar]

If you're using Access 2000+, and use Name Autocorrect (Tools | Options - General tab), Access will normally update all controlsources, queryfield... refererences to the field in forms, reports and queries. If you're addressing the field in code, that would have to be done thru "manually" search and replace, unless you have some utilities for it. I think SpeedFerret might address such, but I haven't used it, so I don't know for sure.

Anyway, simplest way is just to try it on a copy, would probably be a faster way of finding out if it works on you db than asking the question here;-)

To find out how much work a manual change might take, have a look at bboffin's suggestion here thread705-751080.

Roy-Vidar