I've got a weird issue that I desperately need help on.
I've got an Access 365 database with a number of tables linked to SQL Server (2016) via an ODBC connection.
In short the problem is that reading data from SQL is very very slow when I have a form open.
When I open the database in Access and run a lookup in the immediate window, it is nice and fast.
E.g.
?Dlookup("TaskID", "Tasks") //This runs in a few milliseconds.
Now I've created a standard form with 1 field on. The form does not read from table Tasks. In my case it reads from table Companies.
If I open the form in Form View and I run the DLookup as above in the Immediate Window it is slow. Takes about 8 seconds for every execution. Even having the form open in Design view makes the lookup slow.
If I close my form, then the DLookup is quick again. This is really hampering my work as I have other forms that does a lot of database access, and all access is slow.
I've also switched on the ODBC tracing and the sqlout.txt only get created after about 7 seconds, and then 1 second later I have the results. Why does it take so long?
What can it be?
I've got an Access 365 database with a number of tables linked to SQL Server (2016) via an ODBC connection.
In short the problem is that reading data from SQL is very very slow when I have a form open.
When I open the database in Access and run a lookup in the immediate window, it is nice and fast.
E.g.
?Dlookup("TaskID", "Tasks") //This runs in a few milliseconds.
Now I've created a standard form with 1 field on. The form does not read from table Tasks. In my case it reads from table Companies.
If I open the form in Form View and I run the DLookup as above in the Immediate Window it is slow. Takes about 8 seconds for every execution. Even having the form open in Design view makes the lookup slow.
If I close my form, then the DLookup is quick again. This is really hampering my work as I have other forms that does a lot of database access, and all access is slow.
I've also switched on the ODBC tracing and the sqlout.txt only get created after about 7 seconds, and then 1 second later I have the results. Why does it take so long?
What can it be?
Last edited: