# Problem with ADO iterator
**URL:** https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315
**Category:** Discussion
**Created:** [June 30, 2008, 1:18am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315 "2008-06-30T01:18:52Z")
**Posts on this page:** 12
**Page:** 1
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [June 30, 2008, 1:18am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/1 "2008-06-30T01:18:52Z")
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
---
### Author:  [@tate](https://www.finalbuilder.com/forums/u/tate)
#### Post date: [July 1, 2008, 2:10am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/2 "2008-07-01T02:10:49Z")
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](http://www.automise.com/downloads/automise/200/AT200_174.exe)
.t8
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 1, 2008, 8:27am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/3 "2008-07-01T08:27:03Z")
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
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 1, 2008, 8:55am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/4 "2008-07-01T08:55:28Z")
I have now tried executing this only through the atcmd, but this fails with the same problem.
---
### Author:  [@tate](https://www.finalbuilder.com/forums/u/tate)
#### Post date: [July 2, 2008, 3:41am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/5 "2008-07-02T03:41:58Z")
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.
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 2, 2008, 10:09am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/6 "2008-07-02T10:09:18Z")
No problem... here it is.
[TRYG.zip](https://www.finalbuilder.com/forums/uploads/default/original/2X/5/5fab3a167bb67d9687e5d5a3d3d27b655d40b42b.zip) (21.676 KB)
---
### Author:  [@tate](https://www.finalbuilder.com/forums/u/tate)
#### Post date: [July 4, 2008, 8:23am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/7 "2008-07-04T08:23:29Z")
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?
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 4, 2008, 10:42am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/8 "2008-07-04T10:42:35Z")
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.
---
### Author:  [@tate](https://www.finalbuilder.com/forums/u/tate)
#### Post date: [July 7, 2008, 4:00am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/9 "2008-07-07T04:00:33Z")
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.
---
### Author:  [@tate](https://www.finalbuilder.com/forums/u/tate)
#### Post date: [July 7, 2008, 6:14am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/10 "2008-07-07T06:14:37Z")
Bug fixed:
[http://www.automise.com/downloads/automise/200/AT200\_176.exe](http://www.automise.com/downloads/automise/200/AT200_176.exe)
---
### Author:  [@deleted\_user](https://www.finalbuilder.com/forums/u/deleted_user)
#### Post date: [July 7, 2008, 8:48am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/11 "2008-07-07T08:48:46Z")
Just tested, and it has resolved the problem, both my scripts are working fine now. Thank you.
---
### Author:  [@tate](https://www.finalbuilder.com/forums/u/tate)
#### Post date: [July 7, 2008, 8:53am UTC](https://www.finalbuilder.com/forums/t/problem-with-ado-iterator/4315/12 "2008-07-07T08:53:38Z")
Thanks for confirming.