concurrency issues (on aspx page in vb)

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

I have a asp page which uses ado.net to access a access database, and when
two people try to retrieve information from a page that is generated from
the access database, i get the you cant do this the database's state=open
error page... how do i get around this? there will be a lot of users on this
site... thanks!
 
If there will be a lot of users on your site then Access will not be
sufficient. It is not scalable enough and won't be able to handle more than
a few simultaneous users no matter how you adjust your connection string.
You should upgrade to SQL Server.
 
Hi Brian,
I never had this problem or seen this problem, but I would definitly do 2
things:
If the solution only needed reading, I would look why my locking is not read
only.
If it needs writing, putting it in a while loop with inside a try catch end
try catch block.

I don't think that your 2 user problem has something to do with whatever
database you use.
I think that 2 user access should even be possible to handle with a
textfile.
Just a thought
Cor
 
Back
Top