SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Sharing Access Databases

    Hi all,

    For a school project in a few weeks we're going to be required to create a database in Microsoft Access (unfortunately for me, as I am already competent with MySQL!).

    While it may not matter in terms of scoring higher I would like to allow more than one person to be able to open and update the same database without causing sharing violations etc.

    Is this at all possible?

    Thanks

    -Sam
    Sam Hastings

  2. #2
    Chessplayer kleineme's Avatar
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    608
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    yes it is You may host the mdb-file on a network drive from which it can be accessed by, hm..., more than one user. But don't expect it to be a high-end high-performance database. I don't know the exact limitations but it's a simple solution for smaller environments.
    Never ascribe to malice,
    that which can be explained by incompetence.
    Your code should not look unmaintainable, just be that way.

  3. #3
    SitePoint Wizard
    Join Date
    Mar 2002
    Location
    Bristol, UK
    Posts
    2,240
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I tried this before but it still gives me a sharing violation Thanks for the help though
    Sam Hastings

  4. #4
    Chessplayer kleineme's Avatar
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    608
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    I'm using it here (O97/NT4) so it can be done Have you set the permissions for the folder/file to "Change"? What's the exact error message?
    Never ascribe to malice,
    that which can be explained by incompetence.
    Your code should not look unmaintainable, just be that way.

  5. #5
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,651
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    I have done it alot. All users need read/write/create/delete permissions to the folder, as they have to create the LDB file.

    Other thing is to hide the little save object button, as it will lock others out when one users clicks on the little disk icon and saves changes to a form.

    WWB


Bookmarks

Posting Permissions

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