concurrency issues (on aspx page in vb)

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

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

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

[Brian Henry]

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!

[Steve C. Orr [MVP, MCSD]]

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!

[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