Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 A new & exciting error (for me)
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Kerry
Average Member

USA
553 Posts

Posted - 25 March 2001 :  13:06:39  Show Profile  Visit Kerry's Homepage
Has anyone ever seen this one?

"Cannot open any more tables."

It looks like I'm just trying to make the Access driver do too much - but if there's another cause please let me know.

-Kerry

Doug G
Support Moderator

USA
6493 Posts

Posted - 25 March 2001 :  13:44:24  Show Profile
A quick google search showed you're not alone, but I don't know the solution.

This link showed up:

http://www.forospc.com/foro_n3d/active.asp


======
Doug G
======

Edited by - Doug G on 25 March 2001 13:45:24
Go to Top of Page

gor
Retired Admin

Netherlands
5511 Posts

Posted - 25 March 2001 :  14:06:57  Show Profile  Visit gor's Homepage
Doug, the site/page opened fine when I looked....then this probably is something that comes and goes ?

Pierre
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 25 March 2001 :  14:35:33  Show Profile
Yes, the link showed up in Google probably because the error occured when they indexed the site it happened. The page opened ok for me too, I just included it to show another Snitz that has had Kerry's problem.

Sorry for the confusion.


======
Doug G
======
Go to Top of Page

Kerry
Average Member

USA
553 Posts

Posted - 25 March 2001 :  15:24:22  Show Profile  Visit Kerry's Homepage
Thanks Doug - I was hoping you weren't pointing me to a solution because I don't know Spanish! (I think that's what the site was in )

-Kerry

Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 25 March 2001 :  16:32:07  Show Profile
Are you using a DSN? If so, there are some configuration settings available to you that may help. If you go to the ODBC manager and configure your connection, somewhere under an advanced button there are a number of Access driver parameters you can change. A couple that may be applicable are maxbuffersize and threads. I often increase maxbuffersize to 16K and threads to 10.

I think you can set these in the connection string, just guessing if you insert ...;threads=10;maxbuffersize=16284;... but don't hold me to the syntax.

Here is a link to one possibly applicable KB article.

http://support.microsoft.com/support/kb/articles/q248/0/14.asp


======
Doug G
======
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07