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