Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    28

    Unanswered: Can not open exclusive

    Hi, I use AccessXP with ADO to open record in SQL Server. I set Mode property of connection object to adModeShareExclusive before connection object is opened. Before connection object is closed, I open another program to read the same record. Result is It can read.

    I think the correct is It should not able to read, shouldn't it ? How to set to open exclusively ?

    Regards

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Question exclusif

    sorry if i'm wrong but


    i thought it will open to be red but not to be edited

  3. #3
    Join Date
    Nov 2003
    Posts
    28
    It can edit also...

  4. #4
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Exclamation beware of the remarks

    Constant Description
    adModeUnknown Default. Indicates that the permissions have not yet been set or cannot be determined.

    adModeShareDenyRead Prevents others from opening connection with read permissions.

    adModeShareDenyWrite Prevents others from opening connection with write permissions.

    adModeShareExclusive Prevents others from opening connection.

    adModeShareDenyNone Prevents others from opening connection with any permissions.


    Remarks

    Use the Mode property to set or return the access permissions in use by the provider on the current connection. You can set the Mode property only when the Connection object is closed.

    Remote Data Service Usage When used on a client-side Connection object, the Mode property can only be set to adModeUnknown.

Posting Permissions

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