[AccessD] Takes FOREVER to save

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.

If still slow, one option would be to create a blank database and import your objects into it.  May be a corruption somewhere that will generally get caught/corrected in an import to a fresh database.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Tuesday, September 24, 2013 3:21 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Takes FOREVER to save

I always have that 'featured' turned off, (the 'Auto Correct' feature that is. It does not appear to be called 'track changes') but still have long delays in saving changes. ;-(

Using Access 2010. SP2

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Tuesday, September 24, 2013 2:36 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Takes FOREVER to save

I was working on a "user written" database.  It was taking many minutes to save changes.

Turned off "track changes"

Now it saves instantly.

-- 
John W. Colby

Reality is what refuses to go away
when you do not believe in it

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com