troubleshooting Question

ODBC Timeout with Sorted Access Combo Box

Avatar of TechMommy
TechMommyFlag for United States of America asked on
Microsoft AccessMicrosoft SQL Server
10 Comments1 Solution559 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Bitsqueezer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros