By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,685 Members | 1,326 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,685 IT Pros & Developers. It's quick & easy.

concurrency issues (on aspx page in vb)

P: n/a
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!
Nov 20 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net

"Brian Henry" <br******@adelphia.net> wrote in message
news:OX**************@tk2msftngp13.phx.gbl...
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!

Nov 20 '05 #2

P: n/a
well, 100 users total, but i wouldn't expect more then 5 useing it at once.
"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:eY**************@TK2MSFTNGP11.phx.gbl...
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.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net

"Brian Henry" <br******@adelphia.net> wrote in message
news:OX**************@tk2msftngp13.phx.gbl...
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!


Nov 20 '05 #3

P: n/a
That's definitely pushing the limits.
Here are some connection strings you might want to experiment with:
http://www.able-consulting.com/ADO_Conn.htm

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net

"Brian Henry" <br******@adelphia.net> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
well, 100 users total, but i wouldn't expect more then 5 useing it at once.

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:eY**************@TK2MSFTNGP11.phx.gbl...
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.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net

"Brian Henry" <br******@adelphia.net> wrote in message
news:OX**************@tk2msftngp13.phx.gbl...
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!



Nov 20 '05 #4

P: n/a
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

Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.