Sharepoint 2010 with Access 2010 for user who do not have ACCESS 2010

We are attempting to create database accessiable via Sharepoint 2010.  If I create the databases in 2010, can users who do not have 2010 still open the database?  that is, does the database run from the Sharepoint site as 2010?  I know nothing about SharePoint and how it works.  We have ACCESS 2003 installed and that is what is being used currently by users, but we wish to move to a SharePoint environment.

Sandra
Sandra SmithRetiredAsked:
Who is Participating?
 
Rainer JeschorConnect With a Mentor Commented:
Hi Sandra,
depending on the general options you have in regards to coding, it might be a better way to have a custom ASP.NET application which runs inside of SharePoint (hence being able to e.g. store documents, integrated security, reporting services ...).
What type of calculations are run? You should perhaps look at Excel Services (which offer calculations - integrated but also programmatically) in combination with Reporting Services (e.g. data export).

HTH
Rainer
0
 
Rainer JeschorCommented:
Hi,
an Access database published to SharePoint 2010 is no longer a "normal" Access database but it is transformed into SharePoint objects (lists, reports,...) with quite fewer possibilities than an Access database.

Perhaps you may think about using the Access 2010 runtime (which is free) for users who just need to use the database (without the requirement of changing objects in Access).

Overview about Access Services:
http://workerthread.wordpress.com/2010/01/16/thoughts-on-access-services-in-sharepoint-2010/
http://www.opengatesw.net/ms-access-tutorials/Access-2010/Microsoft-Access-2010-Access-Services-Overview.htm
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=54e6aa02-c500-46ba-a930-bfd5c9f43edd&displaylang=en

You would need to have SharePoint Server licensing - not the free SharePoint foundation!

HTH
Rainer
0
 
Sandra SmithRetiredAuthor Commented:
Hi Rainer  This is a financial institution so SharePoint Enterprise is the version.  I can't load anythning on user's machines so a run time version is out.  Actually, you brought up a point about fewer possiblitiies as the databases do a lot of data maniuplation, calculations, scenario determinations and uploads/downloadd of data.  This may not be the route I want to go.

Sandra
0
 
Yagya ShreeCommented:
Found a good post by Ben Clothier who talks about present integration of Access DB with SharePoint

Access Services: Bringing your Access database to the web
http://accessexperts.net/blog/2011/09/19/access-services-bringing-your-access-database-to-the-web/
0
 
Sandra SmithRetiredAuthor Commented:
Am going to try the Excel Services.  Am getting up to speed on JavaScript, C#, HTML, XML, etc.  I am hoping this would be an altetrnative.  Thank you.

Sandra
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.