Cannot open any more tables (ADO/Access)

Posted on 2001-07-19
Last Modified: 2013-12-25

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?
Question by:BobbyOwens
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 70

Expert Comment

by:Éric Moreau
ID: 6299532
Because you are using Access and ADO 2.6, have you installed the JetPackn 4.0?

Author Comment

ID: 6301196
Yes I have. I have also installed Service pack 5 for Jet 4.0
LVL 70

Expert Comment

by:Éric Moreau
ID: 6303294
What is the error number?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 6316213
The various numbers from the error object are as follows:

SLQState: 1311
Err.Number: -2147467259
Connection.Errors(0).number: -85853471
LVL 70

Accepted Solution

Éric Moreau earned 200 total points
ID: 6326963
LVL 70

Expert Comment

by:Éric Moreau
ID: 6331544
Please maintain.

Questions Asked 5
Last 10 Grades Given B B  
Question Grading Record 2 Answers Graded / 2 Answers Received

Author Comment

ID: 6333178
Sorry about that, didn't have a chance to check the pages until today.

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA filters 2 81
Access Object Property from VBA Module in Excel 2010 2 44
I need help embedding an image as HTML in my application 3 84
Help me. 3 78
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question