AutoCorrect naming not working

[WylieC]

I am using Access 2000 and have am using a database I got
as a student file. I need to rename the tables but when I
do the source properties of the queries, forms and
reports are not updated. I did have to enable
Autocorrect, Perform name AutoCorrect, the Track and
Perform name AutoCorrect option on the General Tab. I
then open each object in design view and saved them.
The database is not read only. Any other suggestions?
Thank you very much.

 

[Allen Browne]

You are far better doing this manually.

Name AutoCorrect is buggy and incomplete. There is a list of more than a
dozen known problems from performance issues to crashing Access in this
link:
http://allenbrowne.com/bug-03.html

 

[John Vinson]

I am using Access 2000 and have am using a database I got
as a student file. I need to rename the tables but when I
do the source properties of the queries, forms and
reports are not updated. I did have to enable
Autocorrect, Perform name AutoCorrect, the Track and
Perform name AutoCorrect option on the General Tab. I
then open each object in design view and saved them.
The database is not read only. Any other suggestions?
Thank you very much.

Just to add to Allen's very valid concerns about Name Autocorrect: due
to the lack of any (up until A2000) or any reliable (in A2000 and
later) name change utility, third parties have jumped in to provide
such tools:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com