Cannot open any more tables (ADO/Access)
Posted on 2001-07-19
I am currently experience a problem in an application which returns the above error message. I am connecting to a Jet 4.0 Access database using ADO. I have installed MDAC 2.61 and have all the latest required service packs. My application receives information from the network and does a lookup in a database.
When the function is executed, it creates new instances of a command object and recordset object. The command object then accesses the procedures collection of a catalogue to get to a precreated querydef. The recordset is then set to the result of the command object.
At the end of the function, I close the recordset and set both the command object and the recordset to nothing explicitly.
Has anybody else experienced this problem and do you know the solution?