AutoCorrect naming not working

  • Thread starter Thread starter WylieC
  • Start date Start date
W

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.
 
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.
Click to expand...

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
 
Back
Top