Keep losing mySql connection

[cpampas]

Hello,
I am connected to A Goddday server, that has a 60 seconds timeout, after what the connection is lost and the only way to recconect is to exit Access and enter again.
I have been trying to solve this problem, follwing some of the advice I found in Ms Access forums, but I have not been able to solve it. I confess I am desperate

- Changing the OBDC refresh interval do 50 seconds doesnt work
- to create a passtrough query that would increase timeout , is to complicated to a newbiee as me

I only have one table connected with mySql, and one where I search records
Can I close the connection after each search , pass the result to a temporary table, and recconect again with a new search ?

If So. how can I close the connection
I would appreciate your help
Carlos Alvarez

 

[DavidAtWork]

This situation must be really annoying, does your application write to the database or is the back-end used only to read. If read-only then maybe would be better just to import the required tables when you open Access.
If you write to the back-end via linked tables then I don't see any alternative to re-link each time you want to write. Whatever code you have that executes when the database opens to link the tables, just have a button labelled re-link and use it to execute the same code

David