locked
Access 2013 and Office 365 - Web Database RRS feed

  • Question

  • Can I create an Access 2013 database and host it in the cloud using an Office 365 Developer account in such a way as to be able to allow a prospective client to use the database as a proof of concept project?

    Would the client need a SharePoint log-on or could they just visit a URL and use the database?

    Do I really need Office 365 - can I just use Skydrive?

    • Moved by Quist Zhang Thursday, February 28, 2013 7:12 AM For better support
    Wednesday, February 27, 2013 4:55 PM

Answers

  • Can I create an Access 2013 database and host it in the cloud using an Office 365 Developer account

    Yes, of course.

    Would the client need a SharePoint log-on or could they just visit a URL and use the database?

    He definitely should have a kind of account. It may be Micorsoft Online Services account. Even if he has itw own Office 365 subscription and a corresponding account, you can easily sahre you site with him using his account. There is a term External Users for Office 365. I haven't tested it much yet, but AFAIR there were some troubles with non-hotmail based LiveIDs (e.g. gmail.com). Thus I don't know whether it is still a problem. So in theory someone may be added to your Office 365 site users with his Microsoft LiveID (or however it is called now) like the one you have just used to login to this forum. Some additional info:

    Adding External Members to a Sub-Site

    http://community.office365.com/en-us/forums/148/t/71507.aspx 

    Tutorial: How to add external users to Small Business Office 365 SharePoint Online (P1)

    http://community.office365.com/en-us/forums/154/t/8008.aspx

    Enabling SharePoint Online for External User Access

    http://community.office365.com/en-us/forums/154/t/6346.aspx

    Do I really need Office 365 - can I just use Skydrive?

    Yes, you do. SkyDrive has no SharePoint Online. And for publishing Access 2010 Web Databases and Access 2013 Web Apps (yes, these things are completely different) you need either SharePoint Online (e.g Office 365) or on-premise SharePoint 2010 (2013, depending on what you are publishing) Enterprise  with Access Services enabled.

    Andrey V Artemyev | Saint-Petersburg, Russia
    Russian blog artemyev.biztoolbox.ru

    • Marked as answer by Dummy yoyo Monday, March 11, 2013 5:13 AM
    Friday, March 1, 2013 7:17 AM

All replies

  • Hi Raymond,

    Welcome to the MSDN forum.

    I'm not an expert in Office 365, and I believe you can get more responses for this question in the following community:

    http://community.office365.com/en-us/forums/default.aspx 

    Please try it. 

    For the issue itself, based on my experience, I am afraid that user needs a O365 account to visit the site.

    Good day.


    Yoyo Jiang[MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, March 1, 2013 5:19 AM
  • Can I create an Access 2013 database and host it in the cloud using an Office 365 Developer account

    Yes, of course.

    Would the client need a SharePoint log-on or could they just visit a URL and use the database?

    He definitely should have a kind of account. It may be Micorsoft Online Services account. Even if he has itw own Office 365 subscription and a corresponding account, you can easily sahre you site with him using his account. There is a term External Users for Office 365. I haven't tested it much yet, but AFAIR there were some troubles with non-hotmail based LiveIDs (e.g. gmail.com). Thus I don't know whether it is still a problem. So in theory someone may be added to your Office 365 site users with his Microsoft LiveID (or however it is called now) like the one you have just used to login to this forum. Some additional info:

    Adding External Members to a Sub-Site

    http://community.office365.com/en-us/forums/148/t/71507.aspx 

    Tutorial: How to add external users to Small Business Office 365 SharePoint Online (P1)

    http://community.office365.com/en-us/forums/154/t/8008.aspx

    Enabling SharePoint Online for External User Access

    http://community.office365.com/en-us/forums/154/t/6346.aspx

    Do I really need Office 365 - can I just use Skydrive?

    Yes, you do. SkyDrive has no SharePoint Online. And for publishing Access 2010 Web Databases and Access 2013 Web Apps (yes, these things are completely different) you need either SharePoint Online (e.g Office 365) or on-premise SharePoint 2010 (2013, depending on what you are publishing) Enterprise  with Access Services enabled.

    Andrey V Artemyev | Saint-Petersburg, Russia
    Russian blog artemyev.biztoolbox.ru

    • Marked as answer by Dummy yoyo Monday, March 11, 2013 5:13 AM
    Friday, March 1, 2013 7:17 AM
  • I have the e3 plan but I'm unable access the "access services" in 2013. What do I need to enable to upload my database to sharepoint from officepro plus? I saw the feature in the old version of Access(2010) but not in the nev version.

    Thursday, June 13, 2013 5:07 PM