Results 1 to 2 of 2

Thread: Opening a table exclusevely

  1. Feb 25th, 2000, 03:01 AM #1
    Rafael
    Rafael is offline

    Thread Starter
    Lively Member
    Join Date
    Feb 1999
    Location
    Caracas, Miranda, Venezuela
    Posts
    69

    Post

    Please help me !!!
    How can I Open a table and not the rest of tables from VB exclusevely.
    Reply With Quote Reply With Quote
  2. Feb 25th, 2000, 04:20 AM #2
    Aaron Young
    Aaron Young is offline
    Guru Aaron Young's Avatar
    Join Date
    Jun 1999
    Location
    Red Wing, MN, USA
    Posts
    2,177

    Post

    Use the Options Flags, ie.

    Set oRS = oDB.OpenRecordset("Table1", dbOpenTable, dbDenyRead Or dbDenyWrite) 'Open Table1 Exclusively, Don't Allow anyone else to Read/Write with the Table

    The Lock is Released when the Recordset is Closed.
    Aaron Young
    Red Wing Software, Inc.
    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