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.

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



"Brian Henry" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!
>
>

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


"Steve C. Orr [MVP, MCSD]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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!
> >
> >
>
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> well, 100 users total, but i wouldn't expect more then 5 useing it at
once.
>
>
> "Steve C. Orr [MVP, MCSD]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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!
> > >
> > >
> >
> >
>
>

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