Results 1 to 3 of 3

Thread: VB MSAccess2000

  1. #1
    Join Date
    Dec 2004
    Location
    Laguna, Philippines
    Posts
    147

    Question Unanswered: VB MSAccess2000

    Hi,

    I am creating a local network-based project in vb6 and is using msaccess2000 thru adodb. Database is kept in a central server and users on diffrent computers can access the database at the same time but once an individual user starts editing other users must not be able to modify the table at the same time.

    My problem is how can i know that the current table is being modified by a user so i could lock it and warn other users from modifying it. Please help me.

    Thankz in advance
    Give me a place to code and i shall move the earth!

  2. #2
    Join Date
    Jan 2004
    Posts
    17

    Record Locking

    Configure Access to use row locking so that each user can update their own records or set the default to page locks....

  3. #3
    Join Date
    Dec 2004
    Location
    Laguna, Philippines
    Posts
    147
    thanks for your help, but how can i configure msaccess? is this through hard code or i will go directly to msaccess? if through hard code, what properties and object will i use? if through access where and how will i configure it.

    i appreciate your help... thank u very much again...
    Give me a place to code and i shall move the earth!

Posting Permissions

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