Hi all. First post here. I've read through most of the similar posts on this topic but none are quite the same as mine. I get the error "Invalid SQL. Expected Insert, or delete" when I try to run an append query in access. All other queries work just fine.

Here is my connection string...
==================
Set con = New ADODB.Connection
Set cmd = New ADODB.Command

With con
.Provider = "Microsoft.ACE.OLEDB.12.0;Data Source=n:\Service\ServiceStandards.accdb;Jet OLEDB:Database Password=service"
.Open
End With
====================

These 2 queries work just fine...
con.Execute "qrySSRenewalDelete"
con.Execute "qrySSRenewalDeleteCompletedRenewals"

This one produces the error
con.Execute "qrySSRenewalDErnie"

Any ideas?

The only idea I have without seeing the SQL for the query qrySSRenewalDErnie is that the query is a SELECT query not an action query.

Sorry, my crystal ball in out of order. Please post the SQL for the query qrySSRenewalDErnie so we can take a peek.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

It's an append query. I should also note that it runs fine in access.


INSERT INTO tblSSRenewalD ( [GO], rgName, Analyst, MnthComp, YearComp, ClientID, OverUnder, Completed, Segment )
SELECT DISTINCT qrySSRenewalC.goGroupOffice, qrySSRenewalC.rgname2, tlkpAssistant.asAssistant, qrySSRenewalC.MnthComp, qrySSRenewalC.YearComp, qrySSRenewalC.clMainPol, qrySSRenewalC.OverUnder, qrySSRenewalC.Completed, 'Major and Mid Market' AS Expr1
FROM qrySSRenewalC LEFT JOIN tlkpAssistant ON qrySSRenewalC.Analyst = tlkpAssistant.asUserID
WHERE (((qrySSRenewalC.CompletedDate)>=(#1/1/2017#) And (qrySSRenewalC.CompletedDate)<=(#12/31/2017#)))
ORDER BY tlkpAssistant.asAssistant, qrySSRenewalC.MnthComp;