Changing the names of fields in tables after creating other object

I just leaned about the naming conventions after I have created my tables, 
reports and several queries.  Can I change the name of fields in my tables 
(to remove the spaces and give them unique names ie not just last name but 
childlastname) without destroying the work I have done in queries, reports, 
and forms.

Mary
-- 
Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)
0
Utf
12/17/2009 6:03:01 PM
access.gettingstarted 618 articles. 1 followers. Follow

2 Replies
906 Views

Similar Articles

[PageSpeed] 27

Possibly. If you are using a newer version of Access, say 2003 or 2007 AND 
you have Name Autocorrect, and all it's options, enabled, it MIGHT work. I 
found it somewhat buggy.

Before you start, make a complete backup of the database.

There is a shareware tool that can do the job. Rich Fisher's excellent Find 
and Replace add-in might be just the ticket. If you register it (one of the 
best $37 I've ever spent), the cross-reference report can also find what 
queries use which reports and forms. It's a good way to find orphans.

http://www.rickworld.com/
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Mary" wrote:

> I just leaned about the naming conventions after I have created my tables, 
> reports and several queries.  Can I change the name of fields in my tables 
> (to remove the spaces and give them unique names ie not just last name but 
> childlastname) without destroying the work I have done in queries, reports, 
> and forms.
> 
> Mary
> -- 
> Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)
0
Utf
12/17/2009 8:16:02 PM
No, those other objects use the field names.

There are a couple of 3rd party tools that are handy for the purposes
of globally re-naming fields in all of your objects.  One of them
should be in your tool kit if you plan to do much development in
Access.

    Fina And Replace from www.rickworld.com is shareware and is my
personal favorite.

    Speed Ferret is a commercial offering.  I believe it's from
Moshannon Tools.  I have heard only good things about it too.

Be sure to backup before trying either of those tools on your
application.

HTH

-- 
-Larry-
--

"Mary" <Mary@discussions.microsoft.com> wrote in message
news:9E0E1B47-5923-43E5-BDA3-EC086D30CA3A@microsoft.com...
> I just leaned about the naming conventions after I have created my
tables,
> reports and several queries.  Can I change the name of fields in my
tables
> (to remove the spaces and give them unique names ie not just last
name but
> childlastname) without destroying the work I have done in queries,
reports,
> and forms.
>
> Mary
> -- 
> Positive Direction for Youth & Families, Inc. (www.pdfyinc.com)


0
Larry
12/18/2009 2:03:43 PM
Reply:

Similar Artilces: