>Thanks for your reply,
>
>The documentation says it does not need additional open calls, however I check for that:
>
>

>...
>
>IF cnnSPSS.State = adstateclosed then
>     cnnSPSS.Open
>ELSE
>     cnnSPSS.Requery
>END IF
>
>...
>

>
>Moreover this last time I looked, it also removed all of the data from the table... Only the structure was left... I think I might abandon these attempts and do it manually... this will only be repeated once...

Are you issuing the Requery after each insert? This is not required either. Maybe if you post some code and explain what you are trying to do someone will be able to help.