[AccessD] Takes FOREVER to save

Stuart McLachlan stuart at lexacorp.com.pg
Wed Sep 25 06:23:40 CDT 2013


Sub SetAutocorrect(Status As Boolean)
    Application.SetOption "Track Name AutoCorrect Info", Status
    Application.SetOption "Perform Name Autocorrect", Status
    Application.SetOption "Log Name Autocorrect Changes", Status
End Sub


-- 
Stuart

On 25 Sep 2013 at 6:52, Mark Simms wrote:

> Can these be turned-off via VBA ?
> 
> > I think you are referring to the same settings - "Track Name
> > Autocorrect info" and "Perform Name Autocorrect".  These are what they
> > are called in A2010.  Turning these off definitely helps with
> > performance especially as your database grows in number of forms.
> >
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list