Link to home
Start Free TrialLog in
Avatar of lina_wentzel

asked on

Provide view-only access to MS Access database + using Sharepoint to simulate client/server setup

Hi, at work I have developed a relational database and done take-on into MS Access. The idea was originally that this would be a prototype that would eventually be ported to MS SQL, because a client / server setup and is needed due to geographically dispersed users, and because access control must be set up on a per-table basis ... things I believe are not possible in MS Access.

However, I read snippets suggesting that MS Access might be used in Sharepoint in a manner that facilitates geographically dispersed users - could you please advise?

I would also like to know whether read-only access on MS Access is available free of charge, on a similar basis as Adobe Reader?

Avatar of suvmitra
Flag of India image

Are you working on a licenced version of MS Access, in that case there is no additional cost for administration.

To make the application read only you need to set the user permission from windows explorer where the file is hosted.
Avatar of Jeffrey Coachman

Please be aware that this is an extremely complex question, and a simple "Answer" is not possible without us knowing all of the intimate aspects of this project.
-Your Skill level in Access MySQL, web development, ...etc
-The scope of this application
-Your budget
-Your time horizon.

There are many ways to share data over a wide geographic area. The ones applicable here would probably be:

1. Use a web platform (.net, PHP, ...etc) and MySQL/SqlServer

2. Use Access and Sharepoint.

3. Use a Access Web database

..each of these technologies could be the subject of an entire book or college level class, a real discussion in a forum like this may not be possible.

If it were me, I would go were ever your skills are strongest.

<whether read-only access on MS Access is available free of charge, on a similar basis as Adobe Reader?>
Not really, there is a free  "Run time" version of Access , but you can edit the data (but this gets us a bit off the subject, because there are other ways to make an Access app "Read only")

Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lina_wentzel


Thank you LSMConsulting - your answer as well as Jeff Coachman's give me very good perspective and direction on what I see is not a simple topic - will investigate all your suggestions and come back if I have more specific questions.