too many tables open?

Results 1 to 2 of 2

Thread: too many tables open?

  1. #1
    Join Date
    Dec 1969

    Default too many tables open?

    Has anyone ever seen the following error?<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 8007000e&#039 <BR>[Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables<BR>I get it in an asp page where I have one rs open, and when I try to open a new rs, I get the error below. Is there a limit to how many tables can be open at one time?? The most interesting thing about this error is that it DOES open the second rs, and actually executes the code after it. Any ideas anyone?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: too many tables open?

    I&#039d advise using OLEDB instead of ODBC<BR><BR>"provider=Microsoft.Jet.OLEDB.4.0;data source=c:myDB.mdb" as your connection string<BR><BR>it&#039s faster, and i&#039ve never seen that error with it<BR><BR>j

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts