Update Table Name

[Guest]

The application I am working on is getting more and more
attention from management. They are asking to add more
data to it. To better manage the database, I'll need to
rename the tables, queries and forms.

I just tried renaming a couple of tables, but the change
caused problems in those queries and forms that are
related to one of these tables.

Two problems there I'll need your help:

1. When I change the table name, the underlying query
should be updated automatically. But why didn't it happen
to my application--any setting to triger this automatic
update?

2. I used VBA for all my forms. The table's names are
enbeded in the codes. How can I update the old table name
to new table name in all codes without manually searching
for it?

Thanks,

Shirley

 

[Jeff Boyce]

Shirley

You jest! That sounds a little like a "Hollywood computer" -- you know, the
one where you just push a button and the world defense network reconfigures
to prevent alien attack...<g>

Tables, queries, forms, reports, data pages, macros, code modules -- all
those objects will have to be "visited" to incorporate changes to table
names/field names. If you've used VB to create forms, Access doesn't know
about them -- have you posted to a VB forum for ways to update all your VB
without manual intervention?

There are third party tools, including Speed Ferret, by Black Moshanon and
Total Access Analyzer, by FMS, Inc., that can help you, but I am not
familiar with any automatic feature that does what you are asking.

Good luck!

Jeff Boyce
<Access MVP>

 

[Guest]

Thank you, Jeff!

I found a way: check the autonamecorrect box in tool-
option. But I have to re-save all queries and forms
before I rename tables.

Thanks,

Shirley

 

[Steve Schapel]

Shirley,

And, the reason again why you want to change the names is ...?

- Steve Schapel, Microsoft Access MVP

 

[TC]

Obvious, surely! Previously they were tblJan, tblFeb... Now they need to
be tblMar, tblApr ...



TC

 

[Joe Fallon]

Name autocorrect is limited in comparison to Speed Ferret or the FMS
product.
It will NOT do what you think it should.

You really need the 3rd party tool or else just do it by hand.