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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
To make the application read only you need to set the user permission from windows explorer where the file is hosted.