CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. November 20th, 2001, 06:47 AM #1
    dammansky
    dammansky is offline Member
    Join Date
    May 2000
    Location
    Belgium, Bruges
    Posts
    146

    is an access table open??

    hi,

    i have a program that uses an access database. it could be that 2 users are in the database.
    Is there a way to check if a table is in use (so table, not database) by another user??

    thanx

    Reply With Quote Reply With Quote
  2. November 20th, 2001, 02:06 PM #2
    phunkydude
    phunkydude is offline Member
    Join Date
    Aug 2000
    Location
    Namibia
    Posts
    139

    Re: is an access table open??

    This is possible (in a round-about way). If you use the appropriate locking options on the table (when you call recordset.open) an error will be thrown informing that the table is already in use.
    HTH

    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

Featured