Results 1 to 3 of 3

Thread: Database lock

  1. Jul 24th, 2003, 08:09 PM #1
    Daok
    Daok is offline

    Thread Starter
    Ya ya Baby!!!Me is Back
    Join Date
    Jul 2002
    Posts
    362

    Database lock

    I have a program that are multi-user and one of the window open data that are in a database. I have a button. If I click on it it put all the textbox enable to true and user can edit and save. When save, textbox become enable false.

    What I want is when the user click the button to enable true the textbox to be able to lock the table that he will save the new data. And when he will save withe the save button I want to put back the table available to be written to everybody.

    How do I do that?
    Reply With Quote Reply With Quote
  2. Jul 24th, 2003, 10:54 PM #2
    Toto23
    Toto23 is offline
    New Member
    Join Date
    Jul 2003
    Location
    Philippines
    Posts
    9
    I suggest you use ADO.

    Record locking/unlocking is handled easily using ado Locktype parameters during opening of a recordset.

    read about adLockpessimistic,adLockOptimistic, etc. in VB help.
    Reply With Quote Reply With Quote
  3. Jul 26th, 2003, 11:41 AM #3
    Daok
    Daok is offline

    Thread Starter
    Ya ya Baby!!!Me is Back
    Join Date
    Jul 2002
    Posts
    362
    The problem is that I use db.execute (db is the Database object) to do most of my Edit/Insert so db.lockedit = true doesn't work!!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width