What I did was link to the table in Access, open it, and then click on a column to sort it. So it should have been an identical query.
I thought I'd test it - get Dr Dee Bee Spy to monitor me doing it on the table that worked - and guess what! That table won't sort now, either! I thought that would give some credence to David Jordan's idea of the temp space, but there's masses of free disk space both on my pc and the server. And I don't see how it could be permissions, seeing as it works sometimes and not others. As for different client software etc, we're having problems on at least two pcs. The one we first noticed it on is running Office (Access) 2007, and my pc is running Office (Access) 2003. The ODBC software is identical - installed from a 10.2 client CD. Probably (but not definitely) the same CD. Thing is, we really need to know what's causing it so we can definitely avoid the problem - we don't want to install this on our customer's site and then have them go down with this problem... Cheers, Wol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: 01 July 2008 06:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: ODBC problems Is it the same query for both files/tables (that share the same dictionary)? Do both your queries work from a different client PC? If so, is there different client software versions or ODBC clients? Regards, david -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 01, 2008 12:01 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: ODBC problems What's odd is it looks like it's the PC end getting the query wrong before it sends it, but I've got two files sharing the same physical dictionary file and one works while the other one doesn't ... which implies a data problem ... cue headscratching here ... ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/