[AccessD] Running Access Query With Parameters From VB6

> 
> In my VB application I have a connection to the database inside a
> funtion
> called OpenDataConn and use the following code (dtKPIStart and
> dtKPIFinish
> are the start and end dates).
> strSQL = strQueries(intQuery) & " '" & dtKPIStart & "', '" &
> dtKPIFinish &
> "'"
> Set rsKPIData = OpenDataConn.Execute(strSQL) When I run the program I
> the
> following error message:
> 
> Run-time error '-2147217900
> Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE',
> 'SELECT' or
> 'UPDATE
> 

Do a Msgbox StrSQL before the Set....and post the result.
-- 
Stuart