Web Development

Ask something
Question Locked

Change Table name in MSAccess

0 helpful
3 replies

by jim

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is it possible to change the name of a table in msaccess and have it automatically updated everywhere it appears in relationship, queries, and SQL?
Same question for changing a query name.
My naming conventions werent established until i was halfway done building a database, and nine months into the project, so now half of my naming is systematic so everyone knows what they are, and half of them are run on hungarian notation that only i can decipher.
I have to pass thi project on to someone else so any help would be greatly appreciated.

3 replies

by rwtar

I am facing the same problem as well and i wonder if there's anyway the changed table name will be propagated thorugh out all the queries & any related components automatically? is there anybody out there who knows the answer to this?

by john.a.wills

Certainly changing the name of something on a screen will propagate. Make a copy of your database and change the table name there to test. I have not worked on Access for a year or so, and the details dim in the mind, so I cannot off-hand be more definite.

This discussion is closed to new replies.