MS Access Simple question.......


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: MS Access Simple question.......

  1. #1
    dave Guest

    MS Access Simple question.......


    Hello all

    I have a problem regarding MS Access. I have 3 Access Files on a shared network.
    There are say 2 users . Now if one user is working on one of the access file(
    say c.mdb), i dont want the other user to open that access file . In other
    sense i want to pop up a message box saying that file ( c.mdb ) is in use
    and cannot be accessed.

    How is it possible .I was told you can use COM or sessions can be created.

    Any suggestions on this.

    V


  2. #2
    Arthur Wood Guest

    Re: MS Access Simple question.......


    Dave (or is it Vineet?),
    When the database is opened, open it For Exclusive Use. Then no one else
    can open or access it, until to original opener closes it.

    Arthur Wood


    "dave" <vineet33@hotmail.com> wrote:
    >
    >Hello all
    >
    >I have a problem regarding MS Access. I have 3 Access Files on a shared

    network.
    >There are say 2 users . Now if one user is working on one of the access

    file(
    >say c.mdb), i dont want the other user to open that access file . In other
    >sense i want to pop up a message box saying that file ( c.mdb ) is in use
    >and cannot be accessed.
    >
    >How is it possible .I was told you can use COM or sessions can be created.
    >
    >Any suggestions on this.
    >
    >V
    >



  3. #3
    vineet Guest

    Re: MS Access Simple question.......


    Hi arthur..

    Thanks for the answer. But i am accessing the database through a combobox.
    I have a table where there is the database name ( field 1) and path
    ( field 2). The combobox consists of data from field 1 and when i click on
    the record ( database name in the combo box ) , i actually go in to that
    database( via the path ).

    My question is how can i avoid other users accessing the database , through
    the GUI .

    Thanks
    Regards
    Vineet

  4. #4
    Alex Kennedy Guest

    Re: MS Access Simple question.......


    This is real crude but you could check for the existence of the .ldb file
    for the database - if this file is there then in means that at least one
    person has the DB open. The .ldb file *should* be automatically deleted
    when no-one else is using the DB. Also there are some "unsupported" API
    functions for communicating with Access .ldb file but I can't remember where
    I saw the info on them.

    Btw, if you use this technique then I suggest that you still open up the DB
    in exclusive access mode as well.

    Alex


    "vineet" <vineet33@hotmail.com> wrote in message
    news:<3a914c0a$1@news.devx.com>...
    >
    > Hi arthur..
    >
    > Thanks for the answer. But i am accessing the database through a combobox.
    > I have a table where there is the database name ( field 1) and path
    > ( field 2). The combobox consists of data from field 1 and when i click on
    > the record ( database name in the combo box ) , i actually go in to that
    > database( via the path ).
    >
    > My question is how can i avoid other users accessing the database ,

    through
    > the GUI .
    >
    > Thanks
    > Regards
    > Vineet




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center