Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2010 Runtime and SharePoint 2010

Posted on 2011-03-05
4
Medium Priority
?
512 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 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

971 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