What Office 365 Plans have Access Services

I am trying to find out what Office 365 plans have Access Services. I am not talking about the ability to install desktop MS Access but the ability to put the Access data into the SQL Azure database associated with Office 365 plans and connect a desktop Access database to that data set with read\write access.
Paul-bbcAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Sharepoint is now basically an add-on.   You can get SharePoint Enterprise, or SharePoint Online Plan 1 or 2 to get access services:

https://products.office.com/en-us/SharePoint/sharepoint-online-collaboration-software

Jim.
0
Paul-bbcAuthor Commented:
Now am confused Jim, why SharePoint and not Office 365, I only want one type of cloud service
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
SharePoint (Cloud or otherwise) was broken out of the Office 365 plans.   It's still Microsoft Cloud Services, but it is now not part of any Office 365 plans.   It's an add-on to any of the plans as a separate thing.

It used to be that you only could get it with specific Office 365 plans, but no longer.

It makes sense that you would probably get it in conjunction with an Office 365 plan, but you don't have to.

Jim.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Paul-bbcAuthor Commented:
I have seen Office 365 Enterprise E1 and E3 subscriptions
https://products.office.com/en-gb/business/office-365-enterprise-e3-business-software

It combines the Words 365 and Enterprise E1, is this both? and is this the one to get?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You lost me a bit there.    As for the base office products, it has:

screen shot
That's:

Word, Excel, Powerpoint, Outlook, One Note, Publisher, Skype, and Access.

It also includes Exchange, On-Line Storage, Video Conferencing, Story Telling, and a few other features.

SharePoint and Access Services would be another plan on top of that.

Jim.
0
Paul-bbcAuthor Commented:
When I look at the facilities of Office 365 Enterprise E1 and E3 it lists this:

'Apps for Office and SharePoint', but unlike all the other sections does not have a 'see more' button, is this not that facility?
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<is this not that facility? >>

 No, that is something else.   "Apps for Office and SharePoint" are what was once known as "add-ins".

 So these are small apps (like GeoLocation) that you can add to Office and SharePoint.   But they are not SharePoint, nor are they Access Services within SharePoint that allow you to publish Access Web Apps.  Confused?   You and everyone else<g>

Microsoft has created a lot of confusion ever since they created Office 365 over what's what and it doesn't help that they keep tweaking the plans every year or so.

Jim.
0
PatHartmanCommented:
I'm confused also.  If you created an "Access" web app, I don't believe you need Access installed to run it.  It runs in the SharePoint Web page.  You only need Access installed to create apps or modify them.  It is only if you have a hybrid app where you have web AND desktop components that you would need Access or the Access runtime to run them.

If you are talking about a standard desktop application, then you can run them with the free Access runtime engine download but you need Access installed to create apps or modify them.
0
Paul-bbcAuthor Commented:
I am wanting to use a standard desktop Access application, with its back end data in the SQL Azure db that comes as part of Access Services that is set up for Access web apps. The by product is that you have a central data source for a desktop Access system, in fact it is actively encouraged as a way to get over the lack of reporting utilitites  in Access web apps.
My question is about the Office 365 and SharePoint subscriptions that allow this
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<I am wanting to use a standard desktop Access application, with its back end data in the SQL Azure db that comes as part of Access Services that is set up for Access web apps.>>

 If your not using Access Web Apps, you do not need SharePoint or Access Services that go with it.

You can get Azure alone:

https://azure.microsoft.com/en-us/pricing/

Jim.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
"Azure" by the way started off as nothing more than SQL Server in the cloud as a service.

Now however it encompasses much more.

Still, the bottom line is that for Access Desktop Databases, all you need is SQL Server.  You don't even really need Microsoft for that.   Many hosting companies (like Rack Space), offer SQL Server hosting.

You could even go as far as just renting a server and putting SQL Server on it yourself.

Jim.
0
Paul-bbcAuthor Commented:
Aware of that Jim, but I also feel that end client will probably take advantage of 365 for collaboration given they are going down non-server route and wanted to guide them to a subscription model that gives them and I the facilitites required.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Not sure which way you'd come out ahead (think it would be #1), but for what you want it would be:

1. Office 365, plus a SharePoint plan

or

2. Office 365 and get Azure separate or use a SQL Server hosting service (no SharePoint in this picture).

Jim.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Paul-bbcAuthor Commented:
Yes thank you, option one looks best now you have pointed me in right direction, but hope they can all be done under one account and one set of log-ons
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<but hope they can all be done under one account and one set of log-ons >>

 It would be.

Jim.
0
Paul-bbcAuthor Commented:
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Now you got me, but I noticed your looking at UK sites....there may be a difference between here (the US) and UK.

I know in the past, SharePoint was only included with three Office plans and you could not get it as an add-on.

That article was updated recently, so you would think it would be accurate.  but it may be un-clear in that it might be stating with these plans, here's what you can do with SharePoint and not that SharePoint is included.

 I do know however that some Access MVP's complained loudly that Access Services was not available across the board in Office Plans, and this might be a reflection of that.

 But since your looking to give a client a clear picture and it's a major direction and decision for them, I would call Microsoft in the UK to find out if those Office plans really include SharePoint or not.

  All these changes are very recent (within the last month or so) with the announcement of Office 2016.

Jim.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office 365

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.