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

Re: DSNless connection under DAO

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 users

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

Re: Syntax Check: Group BY with Joins

] 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 having is the last clause (may be LIMIT). David -Original Message- From: Eric