Accessing a MS Access database on a network share by multiple clients.

Posted on 2004-11-23
Last Modified: 2012-06-27
I have written a simple software license tracking program for my company. It is written in C# and uses MS Access as the backend.
I was asked to make the database accessible by several employees all running the same client program on each of their laptops. If just need information
or resources on the best way to do this. Would it be as simple as putting in an absolute path to the .mdb file on the server? Any input would be appreciated.
Question by:ViceroyFizzlebottom
    1 Comment
    LVL 8

    Accepted Solution

    you should be able to just use a network path to the mdb, but you'll have to make sure you have enough rights.
    enough rights is read/write/modify on the FOLDER the mdb is in and the mdb.

    your users will need enough rights to write to the database file but also to put a lockfile in the same folder and/or modify it.

    If there are many users you might run into locking issues, maybe a more network-oriented database would be better.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
    Article by: Najam
    Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now