troubleshooting Question

SELECT DISTINCT statement suddenly not sorting automatically as per usual.

Avatar of jaw0807
jaw0807Flag for United States of America asked on
Microsoft AccessMicrosoft SQL Server
5 Comments1 Solution633 ViewsLast Modified:
I have an Access 2003 application that contains linked SQL2000 tables and a lot of VBA code automation.  I deployed it 2 weeks ago before going on vacation and when I returned yesterday was told that about 2 days ago (while I was still out) it had spontaneously begun losing some of the functionality and exhibiting odd quirks, among them a combo box for which the row source query is a SELECT DISTINCT statement had suddenly started showing up unsorted, which I have never seen before.  I can of course specify an ascending sort but have never before had to do so.  Nothing has changed with the back end SQL database or the Access interface.  The possible changes are automatic MS patches or possible local security changes  (we have been 'consolidated' and aren't usually notified of such changes anymore).  
Among a group of 5 users, these problems are not presenting in the same combinations from user to user and cropped up at different times from some users.  

In particular, can anyone think of what might have caused a SELECT DISTINCT result to suddenly stop sorting itself by default?  I'm wondering if something could be generally preventing Office2003/VBA/ODBC  from performing normally, and if I had an idea of what could be causing the un-sort, that would be a start.

Thanks for any ideas.  
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
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 5 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