Cannot open Sharepoint-created "accdw" database

Question

Question: how to I make a custom database design with tables, forms queries and all the usual DB stuff, and put it on SharePoint 365?

Background: through a process of trial and error, I discovered that (a) I cannot create a database on Office 365 and upload it to SharePoint 365 (b) I can create a database in SharePoint 365 (but not edit it), and ave it offline, where is seems I should be able to open it in Access 365 to edit (i.e. make an actual database with tables and forms that I design - this doesn't appear possible within SharePoint).

Is this workflow documented somewhere? I'm darned if I could find it.

Problem: attempting to open the offline file in Access is a confusing process, and so far unsuccessful. Initially I had to download an addin for Access. That part is simple enough. Then I am prompted to enter the login details for (a) the SharePoint sire (b) something else - not sure what, maybe Office 365 (c) then prompted to login again, still not sure what for.

Finally when all this is done, the following dialog is displayed:

"An error occurred in the client while attempting to communicate with the server "https://<my my SharePoint page URL>..

Contact your system administrator or technical support".

Well I am the System Administrator of my Office 365 configuration and I have no clue why this doesn't work. Actually I am not really sure what it is trying to do.

Answer 1

Hi Colin,

Please let us know the updates at your convenience.

*Note: On June 17th, this community is migrating to Microsoft Community athttp://answers.microsoft.com . If you need further assistance, please post a new question to the Office 365 for business forum beginning June 18th Pacific Time. Thank you for your understanding.

Thanks,

Jim

Answer 2

Hi Colin,

I'd like to share an article with you:

Creating SharePoint Forms with Access 2013 Web Apps

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the download you receive from the third-party linked sites or any support related to the download or the downloaded technology. If you need support relating to the third party technology, please contact the manufacturer directly.

Regarding the error message:

1. It would be great if you share some related screenshots for our reference, especially the web location you had typed.

To upload screenshots, you can click Use rich formatting in the forum and then click the icon of Insert/Edit Media.

2. You may refer to the following suggestions in this thread:

https://community.office365.com/en-us/f/154/t/410449

Thanks,

Jim