You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Tips
How-to
News
Videos
Stories
Recently on The Access Show Ryan and I introduced Access Services and created a donations application that ran in the browser. I thought it would be helpful to provide some background to the vision and direction.
Years ago I came across a post on UtterAccess that articulately described what we hope to accomplish with Access 2010. Stormin on UtterAccess says he is:
… looking for clues to how I could create an Access application that would run from within an Access database, as well as from the web (from a single point of maintenance, of course!).
Reading between the lines a little—Stormin wants to keep all the goodness of the Access as a RAD tool but reap the deployment benefits of the web browser.
As we looked at the long term direction of the product and Office—it was clear that Access 2010 needed to allow users to create databases run in the browser that could live in the cloud. There are so many interesting scenarios for how people need to collaborate in the new global economy—making it easy to share databases is a critical step.
As we spoke with leaders in IT organizations it became clear they were equally interested in a single point of maintenance. In most large organizations it is very difficult to get IT to provide Access users with a SQL Server and ASP.Net web server for small team applications. They are primarily turning to SharePoint as the tool for business users to store all types of information including documents, Wikis, blogs, and lists. From an operational perspective, there continues to be heavy investments in infrastructure to run SharePoint as a server or hosted service (such as SharePoint Online).
Access 2007 forged the initial down payment into SharePoint as a platform for Access databases. Access developers told us clearly there were four things that limited adoption of the Access 2007 SharePoint functionality:
How do you get started with Access Services? It is possible to install it on a Vista 64 bit or Windows 7 machine for developer evaluation. First, you will want to download the SharePoint 2010 beta and install the prereqs. Here is an article that walks you through installing SharePoint 2010. Assuming you want to run reports on your machine you will need to install Reporting Services before installing SharePoint 2010 and enable session state after the SharePoint install. Here is the download for SQL Server 2008 R2 November CTP Reporting Services Add-in. I strongly recommend installing RS before SharePoint. FWIW – we are doing some work post Beta 2 to make setup easier… I think that is the information you need to get started—good luck.
Over the next couple of months we will talk about the work that has gone into these four areas. Next up—Ric will introduce you to publish and we have an Access Show that talks about IT manageability.
Comments: (10) Collapse
Any support for real Web Services, ie. no SharePoint?
The new Access Services looks to be a really exciting evolution of the product and I can't wait to start trying it out. Is there a white paper available that illustrates, for example, how to use the data macros to maintain data integrity and what the best practices are? or is there a sample app we can look at? My only other comment is that it appears that Access Services is only available in SharePoint Enterprise. I know a lot of small businesses that would love to run it on SharePoint Foundation. I know that SKUs/pricing for SharePoint are yet to be confirmed, but it would be great if Access Services could be made available on the other versions of SharePoint for a modest additional cost. These businesses don;t necessarily need all the 'bells and whistles' of the Enterprise version and may not want to go down the hosted services route...
I cannot wait to be able to develop Access databases and be able to upload them like I can with SSRS. Thanks for sharing the steps to get started. Though, I would like to be able to work in a small business who don't know anything about SQL servers and Sharepoint and be able to look at step-by-step guide to making all this stuff work, getting it installed, up and running, etc. I have not reviewed the sharepoint books on the market, but a step-by-step how to linking all the necessary documents and information needed to go from zero to functional. small business don't have the resources or the time to try to figure all out on our own and would love MS to provide a guide to do just that, whether it be MSDN guide, a pdf i can follow, or a published book, step-by-step, us developers don't have the hours to burn in these cash strapped times to research all this and try to get it working. We want to maybe download a DVD and click install and read the guide to tell us how to build this infastructure. So I appreciate the effort here on the blog to do just that.. thanks MS! Though I want to use it and pitch Reporting services and Access Services to management and get it running so could reap the benefits of a web based Access db or build BI/Analytical reports from sql databases..
If we can load the base webservices on say SOHO version of sharepoint just for SSRS and Access Services that would be better than not having a version of share point that doesn't support it. We don't need to have all bells and whistles either like the collaboration, document storage, portal pages, etc, etc.. but I want just a web page to use the Access Services database.. that would be awesome. It would allow faster adoption rates for this and sharepoint if we can say, MS has a base version we can use for reporting.. it just works, its not the full sharepoint, so i cannot do everything, but i could post my report or access database online and you can access if from any computer if you have a browser.. that would be killer.. small business are using Access and some are into Reporting Services.. They need to be able to afford these great tools, but don't need all the amenities of enterprise sharepoint. Just like BO InfoView or HighJump web apps.. it would be cool if there is a was cheap and simple Sharepoint for Reporting version small business can use.
Looks like its only for 64 Bit systems. Where are the 32 Bit versions?
Thanks for the sky feedback. I will pass it along. Joerg--there is only a 64 bit version of the server.
The following step in the installation instructions needs clarification:
----
5.After the installation is complete you, will be prompted to start the SharePoint Products and Technologies Configuration Wizard. Before starting the wizard, first install the Microsoft SQL Server 2008 KB 970315 x64. With the wizard open, do the following: a.Install SQL Server 2008 KB 970315 x64. b.After the Microsoft SQL Server 2008 KB 970315 x64 installation is finished, complete the wizard.
If you're required to install the fix "Before starting the wizard," the "With the wizard open" clause appears contradictory. --rj
The "Microsoft SQL Server 2008 KB 970315 x64 installation" requires KB970315, which requires a hot-fix that includes two files. According to the sharepointserver2010.be/.../Creating-a-SharePoint-2010-staging-environment-part-4-Preparing-and-installing-SharePoint-2010.aspx page, the 381569_intl_x64_zip.exe hotfix "actually contains SQLServer2008-KB970315-x64.exe." The installation instructions offer no guidance as to which of the two files you should execute. The installation instructions should be more explicit as to the hacks required to get SPS 2010 installed, especially on Windows 7. --rj
When the Configuration Wizard attempts to install sample data in step 8, it throws an "Unrecognized attribute 'allowInsecureTransport'" exception. There is a long thread about this issue in the SharePoint Developer forum: Error during SP2010 configure - Failed to create sample data (social.msdn.microsoft.com/.../f239de4a-488e-47e1-8f1e-b382fd4668fa). The upshot is that you must install the following hotfix: go.microsoft.com/fwlink per Paul Andrews' post. This hotfix is for Windows Server 2008 R2 and Windows 7. After applying the above hotfix, the Configuration Wizard finally completed. Paul also notes that WCF HTTP Activation and WCF non-HTTP Activation must be enabled with the script or manually in the Windows Features applet. Another post mentions that the screen captures don't show WCF non-HTTP Activation selected.
WoW !!
That's a real evolution of Access ... Now , I'd hope you do this trick also for Dynamics CRM
Comments: (loading) Collapse