Access and Azure SQL Database
Hello, I tell you that I have the following problem, I connected my access database with an SQL database in Azure, but the communication is very slow, for example one of my forms takes 15 seconds to ...
Forum Discussion
George_Hepworth Well there are many solutions and workarounds for this case..passthrough are read only but you can work with unbound forms and push the data to the server.
And there are others...beyond the scope of a simple question
"...but you can work with unbound forms and push the data to the server...."
Right, that's pretty much what I said. "It can be done but it's ugly."
If performance becomes a work-stop issue, it's worth pursuing such options, but the amount of additional work required is a serious consideration as well. Besides, in my experience, the use of "heavy" forms laden with combo and list boxes and multiple subforms is a more common source of performance lags. That and the old method of binding a form to a table and then searching through that form's recordsource to find one record, that's a killer in terms of performance against a remote database.
Pass-Thrus have a place, along with other design considerations.