concurrency issues (on aspx page in vb)

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!
 
S

Steve C. Orr [MVP, MCSD]

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.
 
B

Brian Henry

well, 100 users total, but i wouldn't expect more then 5 useing it at once.
 
C

Cor

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,731
Messages
2,569,432
Members
44,832
Latest member
GlennSmall

Latest Threads

Top