multiple connections to access DB?

if i have an ASP page that does INSERT's and SELECT's from an access
database,
what happens if more than 1 web user hits the db at the same time? can it
handle it ok or do i have to do something in my code?

Re: multiple connections to access DB?

Joe Reynolds wrote:
> if i have an ASP page that does INSERT's and SELECT's from an access
> database,
> what happens if more than 1 web user hits the db at the same time?
> can it handle it ok or do i have to do something in my code?

As long as you set the folder-level permissions correctly, Access will
handle multiple users.

Are you asking how to avoid concurrency issues?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: multiple connections to access DB?

"Bob Barrows [MVP]" wrote in message
news:O1ZNMIn4GHA.2348@TK2MSFTNGP06.phx.gbl...
> Joe Reynolds wrote:
>> if i have an ASP page that does INSERT's and SELECT's from an access
>> database,
>> what happens if more than 1 web user hits the db at the same time?
>> can it handle it ok or do i have to do something in my code?
>
> As long as you set the folder-level permissions correctly, Access will
> handle multiple users.
>
> Are you asking how to avoid concurrency issues?
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>

thank you. so if the folder the database is in allows read/write for the
IUSR account, is that ok?
i want to avoid weird errors if the site gets busy

Re: multiple connections to access DB?

Joe Reynolds wrote:
> "Bob Barrows [MVP]" wrote in message
> news:O1ZNMIn4GHA.2348@TK2MSFTNGP06.phx.gbl...
>> Joe Reynolds wrote:
>>> if i have an ASP page that does INSERT's and SELECT's from an access
>>> database,
>>> what happens if more than 1 web user hits the db at the same time?
>>> can it handle it ok or do i have to do something in my code?
>>
>> As long as you set the folder-level permissions correctly, Access
>> will handle multiple users.
>>
>> Are you asking how to avoid concurrency issues?
>>
>> --
>> Microsoft MVP - ASP/ASP.NET
>> Please reply to the newsgroup. This email account is my spam trap so
>> I don't check it very often. If you must reply off-line, then remove
>> the "NO SPAM"
>>
>
> thank you. so if the folder the database is in allows read/write for
> the IUSR account, is that ok?
> i want to avoid weird errors if the site gets busy

Yes, if your site use Anonymous access. If not, then all users require
read/write permissions.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"