• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

ASP web site with Access database

We are running an ASP web site with an Access database.  We frequently receive the following error messages:

[Microsoft][ODBC Microsoft Access Driver] Too many active users., The connection cannot be used to perform this operation. It is either closed or invalid in this context., Operation is not allowed when the object is closed.,

AND

[Microsoft][ODBC Microsoft Access Driver] Too many active users., The connection cannot be used to perform this operation. It is either closed or invalid in this context., The connection cannot be used to perform this operation. It is either closed or invalid in this context.,

We used to get these error messages on Cold Fusion sites and were able to remedy the problem by un-checking  "Maintain connections across client requests" in the CF administrator.

Is there a similar solution for ASP?  Is there another solution?
0
hstulberg
Asked:
hstulberg
  • 2
1 Solution
 
Sujith_NairCommented:
hi! there do you have any idea how many users are connected to the DB ? Generally Access is not good enough in handling too many open connections/users. Let me know the traffic of the webpage please!
0
 
hstulbergAuthor Commented:
The answer sent me in the right direction but was not a total solution
0
 
Sujith_NairCommented:
hi! for the sake of KB I will be glad if you share steps that resolved the issue !  

Cheers!
Sujith
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now