Isn't it possible to have more than one OleDbDataReader connected to the same database at once!?

I have made a database representation of a menu, where I use recursion to construct the javascript needed to create the menu. However it seems like the lock file remains after execution. I have checked several times, that I close the proper connections, so I have reason to believe that it is caused by nested OleDbDataReader's connected to the same database. I use Access 2000 for this menu DB.

Does anybody have some experiences with this!? The site works, however the performance is reduced a lot when the file remains.

Thanks

Jacob.

__________________
Danish audio books for download at http://www.lytenbog.dk (Danske lydbøger til download).

I have solved the problem!

I am still interested in comments on the topic. I wasn't able to use different instances of the OleDbDataReader class at the same time on the same database. Some conflict would occur, not removing a lock file.

I solved the problem using an OleDbDataAdapter and DataSet to disconnect the data from the database, and then continuing using this object, however I have heard that this is the heavyweight object, so I do not hope that performance is reduced a lot.

Thanks anyway.

Jacob