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

Posted on 2004-11-23
Medium Priority
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

Accepted Solution

tomvergote earned 300 total points
ID: 12663083
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Summary: Persistence is the capability of an application to store the state of objects and recover it when necessary. This article compares the two common types of serialization in aspects of data access, readability, and runtime cost. A ready-to…
Loops Section Overview
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

864 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