Solved

Access 2010 Runtime and SharePoint 2010

Posted on 2011-03-05
4
473 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

863 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

18 Experts available now in Live!

Get 1:1 Help Now