Access connection - ODBC - MySql Access tables are connected from MySql. Everything is working fine ..

As soon as no more than 1 min activity occurs in the file, the tables are reset, or errors - "#Name?" in all cells

To reconnect, you need (as appropriate):
1. Refresh tables through the "Linked Tables Manager"
or
2. Close, open the form.
or
3. Close, open the file.

Question
How to make that once connected and "forgot"?
And do not twitch with updates ...

  • one
    Open, read everything you need in the buffer, and immediately close. - nick_n_a
  • one
    In the connection properties specify keep-alive. - Akina
  • @Akina I can not find this setting. Could you tell me where she is? - koverflow
  • @Akina Connection is performed according to the following instructions, see screen. prntscr.com/e6lwfo - koverflow
  • It remains to press the Details button >> and read the signature for the third flag on the "Connection" tab. - Akina

0