
data environment - stored procedure - ms access 2000 db
Using vb6 pro with data environment designer. I imported the queries from access
to data environment as stored procedures, which the data environment allows.
I attempt to run the query using the syntax
de.RunMyQuery
where RunMyQuery is one of the stored procedures imported from access.
I get the following error message.
Run Time error -214217900 (80040e14)
Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT'
or 'UPDATE'
My queries are all DELETE, INSERT or UPDATE queries and when I cut the SQL from
access and paste it into the de command, it will run with no problem.
However I have many queries and would like to separate the query activities to
the server not the client.
Any thoughts on what is going on here?
.