Cannot open any more tables (ADO/Access)

Hi,

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?
LVL 2
BobbyOwensAsked:
Who is Participating?
 
Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
0
 
Éric MoreauSenior .Net ConsultantCommented:
Because you are using Access and ADO 2.6, have you installed the JetPackn 4.0? http://www.microsoft.com/data/download.htm#Jet4SP3info
0
 
BobbyOwensAuthor Commented:
Yes I have. I have also installed Service pack 5 for Jet 4.0
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Éric MoreauSenior .Net ConsultantCommented:
What is the error number?
0
 
BobbyOwensAuthor Commented:
The various numbers from the error object are as follows:

SLQState: 1311
Err.Number: -2147467259
Connection.Errors(0).number: -85853471
0
 
Éric MoreauSenior .Net ConsultantCommented:
Please maintain.

Questions Asked 5
Last 10 Grades Given B B  
Question Grading Record 2 Answers Graded / 2 Answers Received
0
 
BobbyOwensAuthor Commented:
Sorry about that, didn't have a chance to check the pages until today.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.