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

What is the syntax of your insert statement?

"Mark" wrote:

> 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
>