Locking Database while writing

Results 1 to 3 of 3

Thread: Locking Database while writing

  1. #1
    Don Botten Guest

    Default Locking Database while writing

    If I use something like:<BR>&#060;%<BR>set conn = server.createobject("adodb.connection")<BR>conn.op en "database"<BR>sqlstmt = INSERT INTO ...........<BR>rs = conn.EXECUTE (sqlstmt)<BR>conn.close<BR>&#037;&#062;<BR>How can I lock the database so that others can&#039t access the database while someone is using it?<BR>don@botten.com

  2. #2
    Stephen Howard Guest

    Default RE: Locking Database while writing

    You can use:<BR>Application.lock<BR>Which database are you using... you do not have to lock the database with SQL Server, I am not sure about Access or any other database.<BR><BR>Stephen.

  3. #3
    Don Botten Guest

    Default RE: Locking Database while writing

    I am using MS Access.<BR>If I use application.lock<BR>do I use application.unlock<BR>after use?

Posting Permissions

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