Solved

Cannot open any more tables (ADO/Access)

Posted on 2001-07-19
7
331 Views
Last Modified: 2013-12-25
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?
0
Comment
Question by:BobbyOwens
  • 4
  • 3
7 Comments
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 6299532
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
 
LVL 2

Author Comment

by:BobbyOwens
ID: 6301196
Yes I have. I have also installed Service pack 5 for Jet 4.0
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 6303294
What is the error number?
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 2

Author Comment

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

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

Accepted Solution

by:
Éric Moreau earned 200 total points
ID: 6326963
0
 
LVL 69

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
0
 
LVL 2

Author Comment

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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
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 utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now