Solved

Access 2010 Runtime and SharePoint 2010

Posted on 2011-03-05
4
504 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

623 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