SQL Insert statement

M

Mark

I have an insert query running on SQL Server. I can run delete queries from a
module in an Access adp using this syntax.

CurrentProject.Connection.Execute "DELETE FROM dbo.HoldTerm"

This works fine and returns to the module to run the next line of code.
However, if I try an insert query it fails to return to the module although
it does run the query. This seems to be the case whether I call a stored
procedure or use the syntax above. The code will fail after the insert? Any
suggestions?
SQL Server 2000, MS Access 2002

Thanks,
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calling Parameterized Query Using SQL Syntax 3
Example Of VBA SQL Statement 0
How do I execute multiple SQL statements in Access?? 3
Update Table Field Value with SQL Query 2
Create multiple queries in Access with a single sql statement 15
Append query in SQL Server, PK error 1
stored procedure query 4
Delete query is passing a select statement to my SQL2000 server database. Why? 1

Top