name autocorrect

[lynn atkinson]

I have a database which is running incredibly slowly when changing from
design view to preview or edit views in all objects. I used to think that it
may be because it had a lot of linked tables, but due to a redesign, it now
only has 1 linked table. It does have a lot of complex reports in it though.
After doing some research, I found a document on slow performance when name
autocorrect is enabled. Although I have full permissions to the database, I
disabled this track name autocorrect option and it now works much faster.
Is this feature important? will I miss it?

 

[Vincent Johns]

I have a database which is running incredibly slowly when changing from
design view to preview or edit views in all objects. I used to think that it
may be because it had a lot of linked tables, but due to a redesign, it now
only has 1 linked table. It does have a lot of complex reports in it though.
After doing some research, I found a document on slow performance when name
autocorrect is enabled. Although I have full permissions to the database, I
disabled this track name autocorrect option and it now works much faster.
Is this feature important? will I miss it?

(I hope some other people weigh in on this, too...)

Short answer is, no, you probably won't miss it.

Some people consider "name autocorrect" to be poisonous, as it's
possible that a name that you didn't want changed will be changed
without your knowledge, and you could have a devil of a time figuring
out what happened. :-(

I usually keep it turned on in the early stages of developing a
database, when it's likely that I will need to change names to reflect
changing contents. It's convenient not to have to run around searching
for all instances of a name. But it's also, necessarily, not
comprehensive; for example, it won't find names embedded in SQL that you
generate in a Module.

If you do need to change names with autocorrect disabled, you'll
probably want to test your Queries, Forms, and Reports to be sure that
you have updated all of the references.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Keith W]

I
disabled this track name autocorrect option and it now works much faster.
Is this feature important? will I miss it?

Name AutoCorrect is evil and it must be stopped. See this
<http://allenbrowne.com/ser-48.html#usability> for info and much more.

Regards,
Keith.
www.keithwilby.com