AutoCorrect naming not working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

WylieC - 11 Jan 2004 03:06 GMT

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.

Reply to this Message

Allen Browne - 11 Jan 2004 05:53 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 5 lines]
> The database is not read only. Any other suggestions?
> Thank you very much.

Reply to this Message

John Vinson - 11 Jan 2004 20:55 GMT

>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
[quoted text clipped - 5 lines]
>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

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message