[AccessD] Access 2007 vs Access 2010 Speed Issues

Rocky Smolin rockysmolin at bchacc.com
Wed Apr 9 14:26:45 CDT 2014


Only in one or two queries in the app.  Odd that. Another app with some
really heavy duty queries has no problem. You'd think some other functions
would be slow as well.  Anyway, if you can get them to sit still for it, and
you can find the 2007 disks or install yours for a trial, it would be
interesting to see if the problem persists or goes away.

WAG: if you look at the task manager processes while it's poking along, is
there anything else that running?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
Sent: Wednesday, April 09, 2014 9:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 vs Access 2010 Speed Issues

Hi Rocky:

Right now, no, since they are a bit disorganized and probably can't find
their Office 2007 disks. I will push for this, however.

So you're also seeing some slowness in the Access 2010 instance?

Thanks!


On Wed, Apr 9, 2014 at 11:47 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> Is downgrading the box to 2007 an option?  If not, I'd at least test 
> can you that by uninstalling 2010 and installing 2007?  If still slow 
> then you know it's not Access.  Do any other apps or functions run 
> slowly?
>
> I'm having this issue with a client now - one machine with 2010 with 
> FE/BE
> -
> FE a 2003 mdb, BE on the server. And not everything runs slows slowly, 
> just a couple of specific queries.
>
> I gave him a few things to check out and haven't heard back.
>
> R
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence 
> Mrazek
> Sent: Wednesday, April 09, 2014 9:38 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access 2007 vs Access 2010 Speed Issues
>
> Hi Folks:
>
> I'm maintaining an application developed (and currently maintained) in 
> Access 2007, and am having a user report back that it is extremely 
> slow since he upgraded to a new computer with Access 2010. The 
> application was developed/compiled in Access 2007 (accdb format) using 
> a standard FE/BE configuration. Other users running on much older 
> computers using Access
> 2007 are not reporting any speed issues ... just this guy (He'll get 
> the "DB Not Responding") message every so often.
>
> Other than the usual suspects, like turning off name autocorrect 
> (done), compact/repair (done) are there any other obvious things I 
> should try? The network folks claim his PC is connecting to the shared 
> drives just fine, so I would hope that it is not a network issue 
> (other network related programs Outlook, etc. work fine for him).
>
> Any hints/pushes in the right direction would be appreciated.
>
> Thanks!
>
> --
> Larry Mrazek
> lmrazek at lcm-res.com
> --
> 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
>



--
Larry Mrazek
lmrazek at lcm-res.com
--
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