Sharepoint Alternatives

Anonymous
2022-12-05T18:17:06+00:00

I'm in the process of rebuilding an Access database which I built. I am the only user of the db.

I tried other solutions since Access web services were removed but nothing has what I'm looking for. Airtable came close but it was so convoluted I stopped using it and came back to Access.

I was told that I should keep my front end locally and move my tables to Sharepoint. So I bought a 365 license and have started rebuilding on a new laptop. I just found out that SHarepoint is not available to me because I have Office 365 personal. Apparently its only available to Students and Enterprise accounts for some reason.

What are my alternatives for storing my tables in the cloud? I was going to keep just the tables in Sharepoint but have all my queries, forms, and reports local on my machine.

Thanks

Microsoft 365 and Office | Access | For home | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

9 answers

Sort by: Most helpful
  1. Anonymous
    2022-12-06T18:14:31+00:00

    Dear Bigshoo,

    Welcome to the forum here.

    To migrate the Access table to a cloud place such as SharePoint Online, you may need to use Microsoft Lists as a data source and then better to move forward with PowerApps. After you get a Microsoft 365 business or enterprise plan, you can use first import or link the data to Excel via the steps in Import or link to data in an Excel workbook - Microsoft Support and create a flow by using Power Automate to sync the data from Excel to Microsoft Lists in SharePoint Online. You can create the flow based on the following template.

    Create an item in SharePoint for a selected row | Microsoft Power Automate

    You can also use some other features with tables in Dynamics 365 which needs the additional price.

    Add a table to the quick create menu in Dynamics 365 App for Outlook (Dynamics 365 apps) | Microsoft Learn

    I'm afraid that Microsoft 365 personal may not support your scenario and you may cancel the plan and buy a business or an enterprise plan.

    For your reference: Cancel a Microsoft 365 subscription - Microsoft Support

    Compare All Microsoft 365 Plans | Microsoft

    Compare Microsoft 365 Enterprise plans

    Thanks for your understanding and have a nice day!

    Sincerely,

    Cliff | Microsoft Community Moderator

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2022-12-07T21:50:12+00:00

    i don't think i have the skillset for that. I'm open to the idea but I don't even know where to begin. I can write some basic code but thats about it. Again, this is just a personal db. no other users.

    A perfect solution would be to allow publishing to the web so I can read data on mobile however that is no longer possible.

    I've been considering of pushing the output to airtable where I can join the data with some APIs and create reports.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2022-12-07T21:47:50+00:00

    Not sure why you find it convoluted, it's standard practice recommended by hundreds of people. A simple google search will show that.

    I want to be able to view my db on the go however since Microsoft removed web publishing, the best option I have is storing the tables in Sharepoint. Then I would run my queries and create a make table query which I would save to sharepoint. that way i can see the data on mobile. This is just a personal db that only i will use and have access to.

    I literally just bought 365 for my new Surface only to find out I can't do what I wanted to do. So I'd have to pay double to add access to sharepoint with a business account, which I believe its $100 per month. I get a discounted rate ($48 annually) on 365 personal through work. 365 business is not offered in the employee discount program.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2022-12-06T21:27:29+00:00

    how about webservice?

    build an ASP dynamic web site to provide data Access。

    Was this answer helpful?

    0 comments No comments
  5. George Hepworth 23,135 Reputation points Volunteer Moderator
    2022-12-06T18:32:54+00:00

    Well, you could upgrade your MS 365 account to be able to connect to SharePoint lists.

    (I can't quite get my head around the convoluted approach to using an Excel workbook or using PowerApps, but I'll leave the task of trying to figure that out to you. Especially so, since PowerApps would also be part of upgrading the MS 365 account anyway.)

    Why do you need to "be in the cloud"? What is the goal? I can see the potential benefit of carrying a laptop "anywhere" and having the ability to connect to the "cloud data". But this is a single-user application, right? Why not keep the back end on the laptop with the FE and avoid the while issue of remote connectivity?

    Again, the objective probably determines what approach might be appropriate.

    Was this answer helpful?

    0 comments No comments