Access Not Responding

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

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" wrote in message
...
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

Sounds like a DNS problem, but it could be anything.

(david)

"Simon" wrote in message
...
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