From: Michael Widenius Date: March 14 1999 3:38pm Subject: myodbc: Query problems using MS Access 7 List-Archive: http://lists.mysql.com/myodbc/22 Message-Id: <14059.55204.610645.665174@monty.pp.sci.fi> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "Bruno" == Bruno Pedro writes: Bruno> Hi all, Bruno> I'd like to know if you had any problems with some kind of queries using Bruno> MS Access 7 and MyODBC 2.50.21? Bruno> I'm having these problems when trying to perform queries using sum(xxx) Bruno> and group by xxx. It usually takes a very long time and some times it Bruno> returns a syntax error. I've tried to do this in many different ways but Bruno> couldn't find anything wrong in my query. Bruno> I don't have the SQL queries with me right now but I will send them as Bruno> well as the table definitions in my next message. Hi! Please do a MyODBC trace log (not an ODBC log) and check the queries Access tries to do! In some case Access generates illegal SQL queries when connecting to remote servers! Regards, Monty