Connecting Tech Pros Worldwide Forums | Help | Site Map

Changin fields' names

Louly
Guest
 
Posts: n/a
#1: May 18 '06
Hi everybody,

I'm not sure if this you've gone through this question before or not.
I'm new in developing. I found out 2 days ago that my tables should
not have fields called (e.g. Name), because this is considered a
keyword. I'm now at the phase of creating reports and I have 11 tables
with afield called "Name". I'm sure some codes are made usind these
fields. Now I don't know what to do?!! All I know is that I really
needs to alter their names. Do I have to go through the system again
to check if codes were made using these fields?

Thanks for your cooperation.

Louly


Tom van Stiphout
Guest
 
Posts: n/a
#2: May 18 '06

re: Changin fields' names


On 18 May 2006 01:54:52 -0700, "Louly" <miro1eg@gmail.com> wrote:

Yes.
If you're using Access 2003, it will attempt to fix up the queries and
other objects that use those names.

-Tom.

[color=blue]
>Hi everybody,
>
>I'm not sure if this you've gone through this question before or not.
>I'm new in developing. I found out 2 days ago that my tables should
>not have fields called (e.g. Name), because this is considered a
>keyword. I'm now at the phase of creating reports and I have 11 tables
>with afield called "Name". I'm sure some codes are made usind these
>fields. Now I don't know what to do?!! All I know is that I really
>needs to alter their names. Do I have to go through the system again
>to check if codes were made using these fields?
>
>Thanks for your cooperation.
>
>Louly[/color]

Louly
Guest
 
Posts: n/a
#3: May 18 '06

re: Changin fields' names


Thank you so much Tom, now I can breath :)

Louly

Closed Thread


Similar Microsoft Access / VBA bytes