Hendra-
Those of us "in the know" humorously refer to that "feature" as AutoCorrupt. It
has been known to cause damage – sometimes irreversible – in you database. You
should ALWAYS turn that off. And yes, it will improve performance. While
you're at it, open each of your tables in Design View, display the Properties
window, and set Subform Datasheet to [None]. You have to turn off AutoCorrect
first, or the change won't "stick." Turning that off greatly improves opening
tables because it turns off opening a sub-dataset on the related table(s).
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
--------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Sunday, April 01, 2012 5:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Allow AutoCorrect Field Properties
Hi All,,, :)
Do we have to set "Allow AutoCorrect" text box property to "No" if we
don't need it..? can it increase the performance ?(If it be setted to
"No")
Regards
Hendra
Tidak ada komentar:
Posting Komentar