[AccessD] Takes FOREVER to save

Yea, me too.  This one I am just helping the guy on.

And yea, it did not fix ALL long save times.

I think that Access compiles all queries for many changes.  If the time to work through those 
compiles is long then it adds up.

I had one odbc table link to SQL Server which whenever I ran a find and replace, it would hang for 
minutes on the query using that linked table.  I ended up doing a pass through and using that 
instead of the table, deleted the table, now F&R runs lightning fast again.

These kinds of things are just strange.

John W. Colby

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

On 9/24/2013 3:20 PM, Heenan, Lambert wrote:
> 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.
>