RE: DSNless connection under DAO

2004-05-12 Thread Victor Pendleton
t;SELECT * FROM items" -Original Message- From: Eric Ellsworth To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 5/12/04 2:11 PM Subject: Re: DSNless connection under DAO Yes - the problem occurs inside the OpenDatabase call, which unfortunately is a native VBA function,

Re: DSNless connection under DAO

2004-05-12 Thread Eric Ellsworth
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

RE: DSNless connection under DAO

2004-05-12 Thread Victor Pendleton
Have you tried stepping through this code to see why the application is prompting 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

DSNless connection under DAO

2004-05-12 Thread Eric Ellsworth
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