V
vp
Is it possible to change a table name and automatically have its name
modified in all the queries that use it ?
modified in all the queries that use it ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marshall Barton
vp said:Is it possible to change a table name and automatically have its name
modified in all the queries that use it ?
No. You could buy (or create) a tool that can search for
the name and modify it, but there is nothing built in that
does that.
K
KC-Mass
Marsh
Wouldn't Name Autocorrect do that for them (at least in post 97 MDBs).
Wouldn't Name Autocorrect do that for them (at least in post 97 MDBs).
M
Marshall Barton
I don't know if, in theory, it should, but I can't trust it
to do anything reliably. It has messed up so many things
the few times I tried to use it that I now hammer that
feature into the off position.
to do anything reliably. It has messed up so many things
the few times I tried to use it that I now hammer that
feature into the off position.
V
vp
I will try Name Autocorect. I thank you for the warning.
At first glance is basic to change the name. Sometimes , when constructing
queries in cascade and otherwise, I find it useful to name the table
diferently.
At first glance is basic to change the name. Sometimes , when constructing
queries in cascade and otherwise, I find it useful to name the table
diferently.
Marshall Barton said:I don't know if, in theory, it should, but I can't trust it
to do anything reliably. It has messed up so many things
the few times I tried to use it that I now hammer that
feature into the off position.
--
Marsh
MVP [MS Access]
KC-Mass said:Wouldn't Name Autocorrect do that for them (at least in post 97 MDBs).
"Marshall Barton" wrote