Re: multiple connections to access DB?



Joe Reynolds wrote:
"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:O1ZNMIn4GHA.2348@xxxxxxxxxxxxxxxxxxxxxxx
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"


.



Relevant Pages

  • Re: 80004005 Unspecified Error
    ... > the warehouse!) ... Can the database be opened in Access? ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: question about ASP with ACCESS
    ... and verify that the path produced is the valid path to your database. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: 80004005 Error & File Permissons
    ... I did as you suggested and all works, except the database can be ... Move the file to a folder outside of wwwroot, ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Cannot Update ADO Recordset??
    ... Again, it's a Permissions issue, specifically, a filesystem permissions ... Database or object is read-only. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Simple update date question
    ... This format is forced on the user, and is not able to be changed. ... The database engine will not recognize that format. ... (EVERYONE has read/write permissions at the moment) ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)