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
    vinman 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
    Adelle Hartley Guest

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

    vinman <vineet33@hotmail.com> wrote in message
    news:3a8da301$1@news.devx.com...
    > 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.


    I think what is happening, is that your mdb file is being opened in
    "Exclusive" mode.

    The simple way of dealing with this is to change the default mode that
    Access
    uses to open databases from "Exclusive" to "Shared". This is on the
    Advanced
    tab on the Options screen (that may vary in earlier versions of Access).
    You will need to set this option on each computer that uses the database.

    Look up "Exclusive" in the help file for more information. And then look up
    "Permission", because ultimately you may want to restrict which users are
    even allowed to open the database in "Exclusive" mode.

    Adelle.

    =============================================
    Impress your friends. Become an SQL Guru. http://www.sql-guru.com




  3. #3
    magnus Guest

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


    Hello,

    one way to solve this problem is to biuld up a system table. When you start
    the application an autoexec module writes say an "-1" into the system table.
    When if somebody else wants to have access to this database the visual basic
    code implemented can show a message saying "The database is currently in
    use! Please try again later". I think application.end in the vba-code ends
    Access after clicking okay in the message box.
    For further information concerning this problem don't hesitate to contact
    me.

    "vinman" <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



  4. #4
    Larry Rebich Guest

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

    Are you using 'native' Access or VB. If VB are you using DAO or ADO or some
    other access method? If using DAO then you can try to open the database for
    Exclusive use. It that fails then some other application has it open. If
    using OpenDatabase then the second parameter is:

    For Microsoft Jet workspaces, you can use the following values for the
    options argument.

    Setting Description
    True Opens the database in exclusive mode.
    False (Default) Opens the database in shared mode.


    Cheers,
    Larry Rebich

    More tips link to:
    http://www.buygold.net/tips.html

    Please:
    No personal e-mail questions :-)


    "vinman" <vineet33@hotmail.com> wrote in message
    news:3a8da301$1@news.devx.com...
    >
    > 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




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