I am converting a Vb.net program to use ADO.NET instead of ADO - part of the program iterates through a number of customer and customer order type database records and populates the same dataset with the appropriate records. It processes them and then clears out the orders (but leaves the customers in a dataset table).
The program works fine when accessing several customers and their orders, but I get the message
'cannot open any more databases'
When going through batch customer and order processing.
I am using Access 2000 tables.
I have found similar questions and it mentions that there are too many table ids, but I ensure connections to tables are closed after accessing records using cn.close.
Is there any way of seeing how many table ids I have and which tables these are referring to?
Could there be another reason why this error is being generated?
Thanks for any help!
Paul
The program works fine when accessing several customers and their orders, but I get the message
'cannot open any more databases'
When going through batch customer and order processing.
I am using Access 2000 tables.
I have found similar questions and it mentions that there are too many table ids, but I ensure connections to tables are closed after accessing records using cn.close.
Is there any way of seeing how many table ids I have and which tables these are referring to?
Could there be another reason why this error is being generated?
Thanks for any help!
Paul