hi
i had asked this yesterday also but one person wanted a clarification which i couldnt give on time..sorry about that...so i am reposting this message...pl.. help
I am currently using ADO 2.0 and OLE DB 3.51 and connecting it to MS Access 97. I have an UPDATE statement in the database. Unfortunately it does not get executed when I use the ADODB.Command.Execute ...it gives me the following error "An action query cannot be used as a row source.". I checked ure online help and all other sources and have not come up against a suitable solution for my problem ...my code looks like this
With dbaseCommand
.CommandText = "[Create New Report]"
.CommandType = adCmdTable
Set dbaseParameter = .CreateParameter("REPORT_NAME", adWChar, adParamInput, 255, P1)
.Parameters.Append dbaseParameter
Set dbaseParameter = .CreateParameter("REPORT_DESC", adWChar, adParamInput, 255, P2)
.Parameters.Append dbaseParameter
Set dbaseParameter = .CreateParameter("PRODUCT_REF", adWChar, adParamInput, 255, P3)
.Parameters.Append dbaseParameter
End With
dbaseCommand.Execute
I have changed the Commandtype to whatever is available in the list and most of them say that "INVALID SQL STATEMENT.....blah blah blah" ...Can you tell me what is the problem and what I should do? The "[Create New Report]" is an UPDATE statement in the MS Access 97 Database side (you know one of those queries that you can create in Access).
its big i know...but its very important...
thanks in advance..
