Run-time error 3014 - 'Cannot open any more tables' 
Author Message
 Run-time error 3014 - 'Cannot open any more tables'

I am coming towards the end of writing a fairly large program, and after
adding several extra queries, every time I run the program I get error
3014 - 'Cannot open any more tables'.

I have 14 recordsets and 32 queries on the one form linked to data controls
and I get the error when I am binding a data control to the 30th query.

Can somebody please give me some advice as I'm coming close to my deadline
and I'm tearing my hair out because of this!

Cheers

Mike



Thu, 04 Dec 2003 22:06:53 GMT  
 Run-time error 3014 - 'Cannot open any more tables'
Mike,

Are you dealing with Jet and Access database?

If yes, what are their version?

Peter



Fri, 05 Dec 2003 14:35:31 GMT  
 Run-time error 3014 - 'Cannot open any more tables'
Peter,

I am dealing with Access 97 and.  How do I find out what version of Jet I am
using though?

Mike


Quote:
> Mike,

> Are you dealing with Jet and Access database?

> If yes, what are their version?

> Peter



Sat, 06 Dec 2003 03:01:44 GMT  
 Run-time error 3014 - 'Cannot open any more tables'
Mike,

You can create a .UDL on the desktop and check if Jet 3.51, Jet 4.0 are under the Providers tab.

Also, please check your code if you have opened too many tables. Can you give us the number or an estimated number of
opened tables when the error occurs?

Peter
--------------------

| Newsgroups: microsoft.public.vb.database

| Subject: Re: Run-time error 3014 - 'Cannot open any more tables'
| Lines: 21
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200

| Date: Mon, 18 Jun 2001 19:01:44 GMT
| NNTP-Posting-Host: 62.31.28.189
| X-Complaints-To: http://www.blueyonder.co.uk/abuse
| X-Trace: news1.cableinet.net 992890904 62.31.28.189 (Mon, 18 Jun 2001 20:01:44 BST)
| NNTP-Posting-Date: Mon, 18 Jun 2001 20:01:44 BST
| Organization: blueyonder (post doesn't reflect views of blueyonder)
| Path: cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.direct.ca!look.ca!news-hub.cableinet.net!
blueyonder!internal-news-hub.cableinet.net!news1.cableinet.net.POSTED!not-for-mail
| Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:72494
| X-Tomcat-NG: microsoft.public.vb.database
|
| Peter,
|
| I am dealing with Access 97 and.  How do I find out what version of Jet I am
| using though?
|
|
| Mike
|
|

| > Mike,
| >
| > Are you dealing with Jet and Access database?
| >
| > If yes, what are their version?
| >
| > Peter
| >
|
|
|



Sun, 07 Dec 2003 14:22:48 GMT  
 Run-time error 3014 - 'Cannot open any more tables'
Peter,

Jet 3.51 and 4.0 are under the Providers tab.

On the main form, there are a total of 14 recordsets and 32 queries.
On the other forms, there are 10 recordsets and 0 queries.

The 32 queries have a large number of tables in them, the total number of
tables in all the queries is approximately 275.

Hope you can help!

Mike


Quote:
> Mike,

> You can create a .UDL on the desktop and check if Jet 3.51, Jet 4.0 are

under the Providers tab.
Quote:

> Also, please check your code if you have opened too many tables. Can you

give us the number or an estimated number of
Quote:
> opened tables when the error occurs?

> Peter
> --------------------

> | Newsgroups: microsoft.public.vb.database



Quote:
> | Subject: Re: Run-time error 3014 - 'Cannot open any more tables'
> | Lines: 21
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
> | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200

> | Date: Mon, 18 Jun 2001 19:01:44 GMT
> | NNTP-Posting-Host: 62.31.28.189
> | X-Complaints-To: http://www.blueyonder.co.uk/abuse
> | X-Trace: news1.cableinet.net 992890904 62.31.28.189 (Mon, 18 Jun 2001
20:01:44 BST)
> | NNTP-Posting-Date: Mon, 18 Jun 2001 20:01:44 BST
> | Organization: blueyonder (post doesn't reflect views of blueyonder)
> | Path:

cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.direc
t.ca!look.ca!news-hub.cableinet.net!
blueyonder!internal-news-hub.cableinet.net!news1.cableinet.net.POSTED!not-fo
r-mail
Quote:
> | Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:72494
> | X-Tomcat-NG: microsoft.public.vb.database
> |
> | Peter,
> |
> | I am dealing with Access 97 and.  How do I find out what version of Jet
I am
> | using though?
> |
> |
> | Mike
> |
> |


> | > Mike,
> | >
> | > Are you dealing with Jet and Access database?
> | >
> | > If yes, what are their version?
> | >
> | > Peter
> | >
> |
> |
> |



Mon, 08 Dec 2003 02:30:25 GMT  
 Run-time error 3014 - 'Cannot open any more tables'
Mike,

It seems that you have opened many tables concurrently.

Can you try close them and open them when necessary? I think this can improve the performance a lot.

Peter



Mon, 08 Dec 2003 11:02:15 GMT  
 Run-time error 3014 - 'Cannot open any more tables'
You can also check this article.

Q165272 ACC: Error Message: Can't Open Any More Tables
http://support.microsoft.com/support/kb/articles/q165/2/72.asp

Peter



Mon, 08 Dec 2003 11:04:13 GMT  
 
 [ 7 post ] 

 Relevant Pages 

1. Please help: run-time error 3014-can't open any more tables

2. Error 3014: Can't open any more tables

3. Error 3014: Can't open any more tables

4. Error 3014: Can't open any more tables

5. Can't open any more tables error 3014

6. Can't open any more tables - 3014

7. ? 3014 Can't open any more tables - Click header to sort by column fails

8. Err 3014, can't open any more tables

9. Run-time error '-2147221231 (80040111)': Automation error ClassFactory cannot supply requested class

10. Error 3014 (too many Tables open)

11. Run-time error '3011' linking table

12. Run-time error '-2147417846 (8001010a)': Automation error (error 440)

 

 
Powered by phpBB® Forum Software