2nd set of several "Insert Into" commands closes application??

[steve728]

After I run a procedure with 10 of the following Insert Into commands successfully once, the second time MS Access 2003 pops up an error message stating that it has encountered a problem and must close the application. After starting again, the first run is fine. The second closes the application again. Is there a need for configuring some area in MS Access or do I need to change my coding? Pleas help

CurrentProject.Connection.Execute "INSERT INTO MyTable (...etc ,,129

Steve
ADO coder, O/S is WinXP with all Svc packs. 768 of RAM,
Processor is a 2.7Mz. No other programs running.

 

[Flippertje]

Exactly what are you trying to do? Copy info from one table to another?
In that case use docmd.runSQL (...)
It could be that the connection part hicks up after 10 times using (i'm not familiar with this)

Hope it helps..

 

[Remou]

This problem seems to have been resolved in:
Do .execute queries take a lot of resources?
thread701-1227144

 

[JerryKlmns]

My CurrentProject.Connection.Execute hasn't hick up after >150 times for years!

 

[Remou]

Well! That's a relief! Did holding your breath stop it? :-D

 

[steve728]

Yes! The issue is solved by installing service pack 2.