MS Access timeout getting a table

360 Views Asked by At

I'm using MS Access as frontend (in Windows), MySQL Server as DB (in RedHat) and ODBC to connect both. I use linked tables in Access.

I have a huge table and always I try to get it, throw an exception: "ODBC--call failed. [MySQL][ODBC 8.0 (w) Driver][mysqld-8.0.16] Query execution was interrupted, maximum statement execution time exceeded (#3024)." (Always at 60 seconds)

I've tried everything. I can't find anything which can help me in the documentation or looking online.

I read post from years ago which mention to use "readtimeout or MYSQL_OPT_READ_TIMEOUT" in the registry editor (regedit.exe) and nothing. In the documentation appear that this option are not available since version 5.1.12.

I have no idea what can I do to delete or increase the timeout. Help!

Versions: MySQL Server: 8.0.16 (Running on RedHat 7.5), MS Access 365 (Running on Windows 10), MySQL ODBC 8.0.15

1

There are 1 best solutions below

0
On

ok, old question, but maybe someone ist still looking for an answer: The timeout is not caused from (Mysql-)serverside. It is a clientside Microsoft Access limit. You can create in Access a query on the linked table and adjust in the query settings the ODBCTimeout property (defaults to 60sec).