Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    10

    Unanswered: Multiple user access

    Hi

    I use ASP to display and edit data from my MS SQL DB, many users need to have access to the same data. But only one can have write access to the same records at the time, who do i solve this problem?
    The other users should get the records in read only.

    Brian Jensen

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    You need to use a LockType parameter when you write data to database, i.e., adLockPessimistic lock.

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    <%Response.Buffer = True%>

    Buffer That Output by Charles Carroll
    http://www.learnasp.com/advice/whybuffer.asp
    Buffering is enabled by default starting in IIS 5, but one must still do it manually in IIS 4.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •