Re: DSNless connection under DAO

pting you with the ODBC dialog box? -Original Message- From: Eric Ellsworth To: [EMAIL PROTECTED] Sent: 5/12/04 11:29 AM Subject: DSNless connection under DAO Hi, I am using Microsoft Access to connect to MySQL 4.0.13-nt on my local machine. I want to use a DSNless connection make sure

DSNless connection under DAO

Hi, I am using Microsoft Access to connect to MySQL 4.0.13-nt on my local machine. I want to use a DSNless connection make sure users don't connect with more privileges than they should have. When I run the code below, I always get the ODBC data source dialog box. How can I suppress this dial

Re: Syntax Check: Group BY with Joins

AIL PROTECTED]> To: "'Eric Ellsworth'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 27, 2004 10:09 AM Subject: RE: Syntax Check: Group BY with Joins > Eric > > Try putting the "HAVING" clause after group by. I believe >

Syntax Check: Group BY with Joins

Hi, I'm having trouble with this query: SELECT Max(DATE_ADD('1970-1-1',INTERVAL Lastupdate/3600/24 DAY)) as BaskDate, ofm_baskets.Code, Sum(ofm_baskets.Quantity) AS TotalQty FROM (ofm_basklist INNER JOIN ofm_basklupd ON ofm_basklist.Session_id = ofm_basklupd.Session_id) INNER JOIN ofm_basket