[AccessD] Takes FOREVER to save

I sometimes have a long wait just to save a few changes to a code module.  Of course it may be my network, over which I have no control here in corporate land.

I work with two Virtual machines, ostensibly identical, but one is much faster than the other???

:-(  'Strange' is Microsoft's middle name I think.

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 3:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [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.
>

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