Hi,
I am experiencing an anoying little problem with an ADO iterator... I am selecting values from an Access query, and just iterating trough it.. something that has worked well until today..now it throws an error as shown on the attached picture...
HH
Hi Hans-Henrik,
Can you try with this test build please and let us know how you go?
http://www.automise.com/downloads/automise/200/AT200_174.exe
.t8
Hi,
I have now tried, but still the same error. I am building two scripts that are going to work in unison. One is creating a list of tasks to be executed, the other is grabbing a task and executing it, as well as scheduling the next. If I create the first one from scratch it works, and if I then create the second, that will work too. But if I go back to the first one, that will fail, and then the second will fail again.
I have also noticed, that there seems to be a problem releasing the database connections?
HH
I have now tried executing this only through the atcmd, but this fails with the same problem.
I’ve done a simple test and can’t reproduce that bug, can you please send us your project and we’ll take a look. thanks.
No problem... here it is.
TRYG.zip (21.676 KB)Thanks,
I’ve tried to run the project but it’s looking for the .mdw system database file I think (I’m no Access expert so not sure what I need to do to get it working). The error I’m getting is:
Error : Cannot start your application. The workgroup information file is missing or opened exclusively by another user
Can you send me this file, or do you know how I can work around this issue?
In the database definitions, just remove the reference. It is not valid for you. But you need to remove it for all, and change username to admin, with blank password.
Hi,
Thanks, got it working now… and found the source of the bug. Somehow the presense of script in the OnAfterEachIteration is causing the problem. If you delete the script, then it works fine. We’ll continue to investigate… thanks for your patience.
Just tested, and it has resolved the problem, both my scripts are working fine now. Thank you.
Thanks for confirming.
