Prev: Need Help Identifying Conrol Causing Error
Next: How to Pass a Parm from VBS script to Access 2007
From: Simon on 20 Apr 2010 17:43
I have an access database, that is running of a mysql server

When i click on button it can take a fair bit of time to respond and
the mouse can frezze. it also says 'Not Responding'

At first i thought it could be internet speed but i have just tested
on a new server with very hight query buffers and not running any
thing else

The query do load fast once Access starts responding again

Abny idea what could be causeing it
From: Jeff Boyce on 20 Apr 2010 18:04
Are you trying to do this across a "wide area network" (e.g., the internet)?
There are some issues with Access' performance on WANs.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Simon" <S.Dickson(a)shos.co.uk> wrote in message
news:5abcaa2e-9e0e-44ef-be3a-c63201f86f5f(a)v20g2000yqv.googlegroups.com...
>I have an access database, that is running of a mysql server
>
> When i click on button it can take a fair bit of time to respond and
> the mouse can frezze. it also says 'Not Responding'
>
> At first i thought it could be internet speed but i have just tested
> on a new server with very hight query buffers and not running any
> thing else
>
> The query do load fast once Access starts responding again
>
> Abny idea what could be causeing it


From: david on 21 Apr 2010 00:54
Sounds like a DNS problem, but it could be anything.

(david)

"Simon" <S.Dickson(a)shos.co.uk> wrote in message
news:5abcaa2e-9e0e-44ef-be3a-c63201f86f5f(a)v20g2000yqv.googlegroups.com...
>I have an access database, that is running of a mysql server
>
> When i click on button it can take a fair bit of time to respond and
> the mouse can frezze. it also says 'Not Responding'
>
> At first i thought it could be internet speed but i have just tested
> on a new server with very hight query buffers and not running any
> thing else
>
> The query do load fast once Access starts responding again
>
> Abny idea what could be causeing it


 | 
Pages: 1
Prev: Need Help Identifying Conrol Causing Error
Next: How to Pass a Parm from VBS script to Access 2007