Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2010 Runtime and SharePoint 2010

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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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.

715 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