Solved

Access 2010 Runtime and SharePoint 2010

Posted on 2011-03-05
4
461 Views
Last Modified: 2012-06-27
I have developed a hybrid Access 2010/Sharepoint 2010 app that I would like to distribute to a selected group of experts for testing. Unfortunately, it will be several months before our company upgrades to Office 2010.

I am wondering if we could use the Access 2010 runtime in this SharePoint scenario (the app consists of a form with a lot of code behind). Will the runtime work with Access Services? Will installing the runtime have any effect on the existing Office 2007 installations?
0
Comment
Question by:dgmoore1
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 35044193
Not quite sure what the question means.

The point about Access services applications is that they run in a browser and don't need Access at all.  There is nothing to install on the users machine.

As long as you have one A2010 to do your development that's it.
0
 

Author Comment

by:dgmoore1
ID: 35044299
My situation is a little different: my hybrid app is a tool for generating xml and html files and runs on the client - it doesn't do anything in the browser. Our company is rolling out SharePoint 2010 as our principal enterprise portal: I am using Access Services/SharePoint 2010 as a means for managing the app centrally - distributing it to users and keeping the apps on the clients up to date. That's why I need Access 2010 on the client and why I am asking if the runtime will work.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 35044413
Then I don't see that it should matter whether you are using the full version or runtime version of Access, but it's not something I've tried and never seen it mentioned in other posts.  To some extent, you can simulate the runtime in full access using .accdr and/or the runtime switch.

In A2007 runtime you couldn't take offline copies of the sharepoint data. It looks like this might have changed in A2010 but I haven't used it.
Just googling before hitting submit for  this response I came across this.
http://social.msdn.microsoft.com/Forums/en/accessdev/thread/069efb64-c1ce-40c1-83bb-46eeb300fc8d
0
 

Author Closing Comment

by:dgmoore1
ID: 35044526
This post is actually very helpful - since I'm not writing any data back to the server it sounds like the runtime on the client may do the trick. We're rolling out the enterprise portal in late spring and are developing a large number of enterprise program management tools. Mine is the only one that uses Access on the client, but since it's entirely code based it can't execute on the server.

Thanks for the pointer!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now