[AccessD] Takes FOREVER to save

I am working on a directory on my C: drive.  I have an F: drive which is my automatically backed up 
place to store things which need backing up.  It is on a server on the other coast of the US.  It 
has to go through about 10 firewalls (so I am told) to get out of this building, to the internet and 
into the system on the other coast.  Needless to say, we use a local drive and I use sync toy to get 
things synced up off line at night.

And yes, it runs much faster in the citrix VM but no changes I make to those VMs survive a reboot.

Needless to say I use a local hard drive for dev.

Doing so though means getting at data in a SQL Server on the opposite coast....

John W. Colby

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

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