Avatar of lina_wentzel
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?

Thanks
Lina
Microsoft AccessMicrosoft SharePoint

Avatar of undefined
Last Comment
lina_wentzel

8/22/2022 - Mon
suvmitra

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.
Jeffrey Coachman

Linda,

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.
...ect

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, ...so 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")

JeffCoachman
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck