ODBC Timeout with Sorted Access Combo Box
Posted on 2014-08-08
I have encountered a very odd problem.
My client is using SQL Server Express 2014 with Access 2013. Everything works great except for one strange thing. I have a combo box on a form which is used for searching for the product selected in the combo box. The combo box is bound to the primary key field, ProductID, which is hidden. The combo box displays the ProductName which is an nvarchar(35) and is indexed. When I sort on ProductName in the combo box, and the user tries to edit data in the retrieved record, they get an ODBC Timeout error. When I simply remove the sort, making NO other changes, the search works perfectly, and the data can be edited as expected.
I use this identical technique on many other forms, based on many other tables, and it works beautifully.
Has anyone ever experienced this problem?