Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Unanswered: Locking records with SQL through ODBC.

    I am connecting to a MS-Access database through an ODBC connection and I want to lock a particular record using a SQL statement.

    In most databases, issuing something like the following would do the job :

    SELECT col1, col2 FOR UPDATE
    FROM tablename
    WHERE condition

    This doesn't work with MS-Access. Anybody has an idea of how I could lock a record in SQL ?

    Thanks.

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: Locking records with SQL through ODBC.

    Originally posted by bstjean
    I am connecting to a MS-Access database through an ODBC connection and I want to lock a particular record using a SQL statement.

    In most databases, issuing something like the following would do the job :

    SELECT col1, col2 FOR UPDATE
    FROM tablename
    WHERE condition

    This doesn't work with MS-Access. Anybody has an idea of how I could lock a record in SQL ?

    Thanks.
    Anyone has a hint/suggestion/answer ?

Posting Permissions

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